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.