Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hey, is there a way to set the max() function to find for like the second bigger number in a list instead of the bigest one? if not, is there a way to to put an "except" fonction while selecting data? ex: H:H except(H85) or H:H\H85 This way I could do somehting like MAX(H:H except(H85(which would be the bigest number in the column)) This function would then show me the second biffer number in H:H as I rejected the H:85 hope you understand, please reply fast, thanks -- anyways ------------------------------------------------------------------------ anyways's Profile: http://www.excelforum.com/member.php...o&userid=31815 View this thread: http://www.excelforum.com/showthread...hreadid=515377 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
fonction SI + max dans la meme cellule | Excel Discussion (Misc queries) |