Labeling 1st through 11th place

P

psilzle

I have an excel file that has 11 place standings and I want a column to
look at another column and label who has 1st, 2nd, 3rd, etc... How
would I go about doing that? I can get it to find the largest or
smallest number in the set but no the other ones. I want it to update
as the numbers change as they will each week.

Help.....

Thank you in advance,

Paul
 
B

Bob Phillips

=LARGE(A1:A100,1)
=LARGE(A1:A100,2)

etc.

will get them all

or a copy-able formula

=LARGE(A1:A1,ROW(A1))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Locate text in range (multiple occurrences) and report other cell insame column? 10
Matching partial portions of cell contents 8
IF Statement using several columns 3
1st smallest, 2nd smallest,3rd smallest 6
Simple Macros (i hope) 2
Sorting 1st, 2nd, 3rd... 3
How do Count a the number of times a date range appears within a date range!? 5

Top