Ranking Table

S

SteveC

In Sheet1 I have data in ColB. It's about 1000 rows.

In Sheet2, I'd like to list the Top 5 and the Bottom 5.

I know how to use RANK formula in Sheet 1, say in ColC -- but no clue how to
construct an output table using RANK to get the top 5 and bottom 5...

Any suggestions? Thanks very much.
 
S

SteveC

Yes, that worked, thanks. I used it in conjuction with the Index Match combo
in other columns to pull the names associated with the rankings.

e.g.,
=INDEX('Sheet1'!$D$2:$D$224,MATCH(C4,'Sheet'!$G$2:$G$224,0),1)

with c4 referring to a number, and index finding the name associated with
that number

to get

company name, company symbol, top 1-5 and bottom 1-5 figures
 
Top