Help with formula searching for 2nd lowest value, then return value in next column
I've attached a screen shot of what I'm trying to do:
As part of a larger spreadsheet, I have 7 columns of data. I want to choose the 3 smallest values in A7:A13 and average them. I can do this no problem, and the formula has been put in A2 with the correct result
I then want a formula to select the three lowest in ColA, and then give me the average of the corresponding values in ColB. Then I need to do the same for the rest of the columns.
For example, A9, A11 & A13 have the smallest values, so I want the average of B9, B11, & B13 (but with a formula so I don't have to chose the smallest values)
Thanks for your help!!!
Re: Help with formula searching for 2nd lowest value, then return value in next colum
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1