Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

Need to average values from cells in column B that correspond to matching criteria in cells in column A. Averageif function returning #DIV/0
Solved by M. F. in 26 mins
Hi please see the formula in column AU on the attached. I am trying to work out why I get #N/A whenever the value in AP = "No Work Orders". Is it something to do with the fact that this comes from the formula in AT?
Solved by A. J. in 20 mins
Could you help me with Column A "Date of Sale" Column B "Sales £" What is the excel formula for sales in january, sales in geb, sales in march etc etc? Many thanks
Solved by T. H. in 24 mins
I need to use birth date in one column and date of entry into program in another and round to the nearest tenth decimal
Solved by T. Q. in 40 mins
How can I check for duplicate phone numbers across these 5 columns but still keep duplicates that are from one column?
Solved by A. C. in 28 mins
I need a formula to calculate the MAX of a range of 167 rows in column D, then find the MAX of the next 167 rows in column D and so on continuously through the entire sheet. Example MAX D2:D169, D170:D337, D338:D505 etc...
Solved by I. Q. in 60 mins
hi i need to change all the numbers in a column to negative ones?
Solved by D. D. in 21 mins
Hello, I obtained an .xls file that I need to do work on and at least one tab that I am working on finishes in column IA. Other tabs finish in column IV, which is the higher limit to the right for .xls files. I have converted it to .xlsx and the above did not change. How can I view up to column IV at least for the tab that goes up to IA? Thanks in advance. Demetrios
Solved by A. B. in 16 mins
In column A I have 1500 lines of data, some of these are valued at zero, I need to write a formula which removes the values of 0 and then gives me a sum of the unique names in column b. I am aware I could filter column a to remove "0's" and then remove duplicates from the remaining cells in column B, but this must be done in a formula
Solved by O. Q. in 56 mins
I need to multiple a column then round to the nearest 9 whole dollar while staying in a single column so i need to take the product then round it to the nearest 9
Solved by B. B. in 21 mins
1 2 7 8 9 128 129

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc