“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

HELP!! i need to fill the codes in the appropriate headings and the function ia m using is only pulling the first code from the ref table

Solved by X. H. in 11 mins

how to create pivot table in excel? I have created a pivot table and want to create a calculated field representing the percentage of hospitalizations (hospitalizations divided by population). I am having trouble with this as the calculated field option is disabled. Please help! I am desperate

Solved by O. J. in 19 mins

Hi, I need help activating a slicer for my pivot table to create pivot charts. The slicer function is disabled.

Solved by X. C. in 27 mins

in the commission worksheet, i am trying to create a one variable data table excel using cells a4:b14 to determine how much that commission may be. the column input cell is a4.

Solved by O. B. in 15 mins

I need to create dashboard containing 4 charts(pie or histogram or any) and pivot table data

Solved by D. H. in 23 mins

Hi I have attached a pivot table I created to get counts for a set of data. I am unable to figure out how to get the count of gender to categorize by male, female and unknown. It is only giving me the overall value for each of the rows and columns selected.

Solved by C. L. in 21 mins

Data is seemingly arbitrarily split into two columns in the pivot table, and I can't figure out why. In the purple worksheet "Lecturer totals T1" you'll see two columns for "All". On "Lecturer totals 01-17" you'll see "BaL" and "HLS" twice. On "Lecturer totals T2 & 3" there are two columns for each of "All", "BaL" and "HLS". On the green "Faculty totals T1" worksheet, "All" has two entries. There are similar cases in the other worksheets.
I've tried applying the "=ISNUMBER" function to each of the cells containing "All" in the data (the red worksheets). These return a FALSE reading, which (if I understand correctly) means that they're text, which is what they should be.
Depending on when you answer, I might not be able to continue the conversation before tomorrow around 0900.

Solved by Z. Y. in 29 mins

I'm trying to produce a pivot table on worksheet H showing the number of records by hour for each room based on the NYC (eastern) time. This will require the provided LogTimeStamp time to be converted to our EST from GMT listed in the table worktable worksheet

Solved by X. B. in 26 mins

I have three steps I must do which involves me dealing with vlookups and no matter what I look up, I am still confused and can't get my formula to work. I need help please!
step 1: Switch to the worksheet “Internet user and pop. Table”. Use a VLOOKUP function in cell F2 so that it searches for the country in A2 (of current worksheet) that also appears within the “2016” worksheet and display its number of internet users. Expand the formula down to find the number of internet users for each country.
Step 2:In the cell G2, use a similar VLOOKUP function to display the population for that country. Expand the formula down to find the population for each country.
Step 3:In cell J2, use a formula to calculate the % of the population that uses the internet. Use the same calculation for each country.

Solved by D. Q. in 25 mins

I cannot figure this step out and need help please.
Step 1: At this point, a smaller list of countries should be visible in the worksheet “Internet user and pop. Table”. Cross reference these countries with the list of tech ready countries in the “Tech Readiness 2016” and highlight in the “Internet user and pop. Table” worksheet the country or countries that are in both lists. You may choose any shade of orange as the highlighting color. Cross reference them using conditional formatting.

Solved by K. D. in 20 mins