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.

LARGE(Sheet1!B1:B1000,1)
SMALL(Sheet1!B1:B1000,1)



"SteveC" skrev:

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.

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


"excelent" wrote:

LARGE(Sheet1!B1:B1000,1)
SMALL(Sheet1!B1:B1000,1)



"SteveC" skrev:

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.