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.