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

Trusted by people who work at