INDEX(LARGE( across worksheets
On Feb 13, 6:20 am, "Fin Fang Foom" wrote:
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.
Bump!
|