I also want the store # with it. Example. Sheet1 Column A is the store #,
Column 2 is the sales. I want to return both columns based of the highest
sales.

"Gary''s Student" wrote:

Say your original data is in Sheet1 column A. In Sheet2, A1 enter:

=LARGE(Sheet1!A:A,ROW()) and copy down

The highest value will be first, the second highest nextm etc.
--
Gary's Student


"Marcus" wrote:

Hello,
What I am trying to do is get a ranking based off of data. Example: I
have a database with store #'s and their sales. I want to be able to rank who
did the best in sales on a 1st, 2nd, 3rd, and so on, and return it to a
different sheet than what the data is kept in. Anyone got any ideas???