Sure. Just attach it using the paperclip icon. Then you can explain what it is that you are trying to do.
No problem. Go ahead and explain what you are trying to do while I take a look.
Alright. Give me a minute.
Ok, well first we need to fix the errors on I and J, then we can fix L. How quickly do you need this done?
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.
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).
Can you send me a sheet with a full set of rows? Or at the very least 9 rows? Does col I look correct in your set of data? How about col J?
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.
That's fine. Just let me know when you're ready to continue.
Did you still want to work on this, or have you found another solution?