Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX(LARGE( across worksheets
I would like to get this formula below to work across worksheets.
=INDEX(A$1:A$99,MATCH(LARGE(IF(RIGHT($A$2:$A$100,5 )="Total",IF(LEFT($A $2:$A$100,5)<"Grand",$B$2:$B$100-ROW($B$2:$B$100)/10^5)),ROWS(D $2:D2)),$B$2:$B$100-ROW($B$2:$B$100)/10^5,0)) The formula above list names from column A that has the largest number in column B. It also accounts for duplicates. Any Ideas will be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LARGE and INDEX functions | Excel Worksheet Functions | |||
Large Index Match Lookup | Excel Worksheet Functions | |||
Experience with VERY large worksheets | Excel Discussion (Misc queries) | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions |