Search results

Hello, I have this formula below, which averages 10 data points from a different spreadsheet onto this new spreadsheet and if the cells are empty fills them with the average. However, when I drag the formula across to other columns, it uses this same average calculated from the previous 10...

Hello, I'm trying to consolidate health care data from multiple hospitals into one worksheet. However, some of my numerical data contains hyphenated numbers (i.e. 10-20 instead of 15). Is there a formula that can turn this range into one averaged number or do I have to manually change these...