ok. column L has formulas written. because there are spaces, I can't sort properly or at all. I need to find all the results (yes, no, and #sum) and list the column A, H, I, J next to those results in ascending order on a separate tab and be able to sort. Or if there is an easier way, I am open.

what errors are you referring to? the formulas in H require 3 scores, and if there are not 3 scores, I am ok with the result "#sum" time frame- tomorrow or Thursday will be fine. What am I dealing with here-- formulas or macros? Thanks- DA

Customer:replied 1 year ago.

Sorry--- the formulas in I require 3 scores, Not H

This can all be done with Formulas. I am getting #NUM calculation errors that I need to fix before I can work on the L calculation. Which version of Excel are you using? Or are you using a different spreadsheet app than Excel? I can get to work on this and should have it for you sometime within the next 12-18 hours.

I am unsure of the excel version I am using. probably 2000. If any player does not have three scores, I would prefer a result of "not enough scores" or "#sum" is fine too. If you think my formulas throughout the sheet are not adequate I am open to that. This sheet attempts to calculate player's best three scores (and differential as shown in the formula), and which player's best three as compared to their GHIN handicap which is a manual entry, not a formula. Thanks-

Ok. That could be why I am getting an invalid number calculation on those columns. I will need to install Office 2000 to verify that. Are you using Windows for this? And if so, do you know which version?

Ok. I'm running Office 2013 in Windows 7 Pro. I'll install 2010 to make sure we keep compatibility. I'll have something for you tomorrow (12-18 hours from now).

My request for the extra data has to do with the Average function used in Col I, which in turn affects Col J. Which is also my reason for asking about those Columns.

What is Column I supposed to represent? And how does it change based on subsequent rows? I just filled in fake values for G8 (11.6) and G9 (11.7) to get the Small calculations to work (since you are trying to retrieve 3 values, it needs at least 3 values to work with. I could have used any other 2 rows in G, I just chose those two because they were there). The Average of those will always be 11.6 (just because of the fake values I put in). So depending on how the formula changes for subsequent rows, it will either stay 11.6 in col I for all rows, or it will differ if you average other cells.

Then we come to Column J. I'm not sure why you are using =SMALL(I7:I7,1) because it's not an array that is stored in I, just an average of the 3 Small values. You could have just as easily used =I7

However, once I put in the fake data, I got rid of the #NUM error in I and J plus got a "No" in L

So that's why it would be best to have more data and an explanation of what the data should look like in Cols I and J. Once we get those worked out, then we can move on to your original problem.

I see. Thx for the elaboration. Entering fake values to eliminate the #SUM results is fine because as I add more scores, I will override your fake entries anyway. I will look into col J. The formula should have been looking at column H and I, not just I. I will let you know when I can get back to a computer. Might have to be after work later today.