I want a formula that can be used to get the value that is lowest among the maximum values in the other column
if you find it difficult to understand what I am saying, please see the attached sheet
thanks in advance
formula.xlsx
I want a formula that can be used to get the value that is lowest among the maximum values in the other column
if you find it difficult to understand what I am saying, please see the attached sheet
thanks in advance
formula.xlsx
Why 6? Why not 5 for example?
=INDEX($B$3:$B$10,MATCH(MIN(INDEX(($B$3:$B$10-$C$3:$C$10),0)),INDEX($B$3:$B$10-$C$3:$C$10,0),0))
Try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
I Hope it is what you are looking for
=MIN(INDEX(($C$3:$C$10<>MAX($C$3:$C$10))*10^10+$B$3:$B$10,0))
Pls ignore post no #3
Try this modified version of the formula you have in B14.It will return the 6 matching the last 15 in column C.Formula:Please Login or Register to view this content.
Is this what you want to do?
Or this:
Confirmed with ctrl+shift+enter
Formula:Please Login or Register to view this content.
Thanks a lot for the quick response ....that seems exactly what i am looking for..will save a lot of time..BTW formulas given in posts 4 and 7 is giving the results i wanted..so thanks all those replied once again..
Last edited by shamym; 01-21-2015 at 05:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks