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

I need help creating a custom list on excel on my MacBook. There is no "NEW LIST" button when I select custom list for the order I want my data to be sorted in.

Solved by T. L. in 23 mins

Context: Reading and Spelling age score sheet (eg. a student takes a test and it tells them what their 'reading age' is- 14.03 would be 14 years and 3 months).
Problem: Need to calculate progress for each student + average progress for each year group.
Issues: Have tried converting ages to months using this formula (=12*LEFT(C11,FIND(".",C11)-1)+MID(C11,FIND(".",C11)+1,9)) but ran into various issues (treating .10 as .01 for some reason and producing #VALUE error for scores ending in .00 (presumably because MID function won't work if value below 1)
Action: Have gone back to raw data set (attached). Can you help?

Solved by F. A. in 17 mins

I am trying to find a value less than a certain number in two columns combined.

Solved by S. Q. in 18 mins

Hi, I am trying to compare 2 sheets in excel.
I wanted to use Vlookup but not sure how to set it up correctly.
So if an item on sheet 2, exists on sheet 1 (the master file), I want it to return a value in column 4 on sheet 1. Can someone please help?

Solved by B. B. in 21 mins

how to pull cell data from one tab to another if the original cell's corresponding column is either yes/no

Solved by O. H. in 17 mins

Hi - looking for help with the solver add-in on how to best utilize a use of length of 2x4's. Is this possible?

Solved by G. J. in 17 mins

How do I get excel not excel online? I am a university student so i get office 365 free.

Solved by B. J. in 11 mins

I want to remove an excel mail merge list from a word document and replace it with a new excel mail list, but the old list doesn't delete.

Solved by M. J. in 25 mins

how do I find all the formula in a multi sheet workbook that point to a particular cell?

Solved by B. S. in 18 mins

I am trying to enter the following formula in Excel, and I am being told that I have entered too many arguments. I thought however the max was 7, which I do not have. Formula entered:
=IF(AND((M8>40),(M8<=50)),((M8-40)*O8),IF(M8<=40,0),IF((M8>50),(10*O8)))
Purpose is simply to state that if Cell M8 is over 40 but under or equal to 50, then I want to subtract 40 from it, and multiply it by cell O8. If M8 is less than or equal to 40, just enter 0, if M8 is greater than 50, I simply need it to multipy 10 by cell O8.

Solved by T. C. in 13 mins