Hi all,
I want to list in col A the 20 top company in terms of a count i have in Col b.
ColB has has a $ count and i know i can get teh top 20 values from teh column easily using =LARGE(B:B,1), =LARGE(B:B,2)..... =LARGE(B:B,20) in column A
However, I do not want to return the VALUE of the count, i want to return the company, which is listed in Col D, so it is offset by 2 columns of the count.
I was thinking something along the lines of = OFFSET( EQUATION , 0 , 2) where in EQUATION i can somehow get teh reference of the cell where I am getting the Large values from? Any idea how i can get the cell reference and not just the values themselves?
=OFFSET( CELL("address",LARGE(B:B,1)) , 0 , 2) did not work
Bookmarks