Pulling larger numbers from group
 

How would I be able to pull 3 of the largest numbers in a list of 4 numbers
and list them in their own cells right next them.
IE.
100 100
80 80
20 70
70

Where the smallest number is left out but the three highest are displayed.
Thanks

Smint, here is one way, = LARGE(A1:A4,1) = LARGE(A1:A4,2) =
LARGE(A1:A4,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Smint" wrote in message
...
How would I be able to pull 3 of the largest numbers in a list of 4
numbers
and list them in their own cells right next them.
IE.
100 100
80 80
20 70
70

Where the smallest number is left out but the three highest are displayed.
Thanks

That worked out great. Thanks

"Paul B" wrote:

Smint, here is one way, = LARGE(A1:A4,1) = LARGE(A1:A4,2) =
LARGE(A1:A4,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Smint" wrote in message
...
How would I be able to pull 3 of the largest numbers in a list of 4
numbers
and list them in their own cells right next them.
IE.
100 100
80 80
20 70
70

Where the smallest number is left out but the three highest are displayed.
Thanks

Your welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"smint" wrote in message
...
That worked out great. Thanks

"Paul B" wrote:

Smint, here is one way, = LARGE(A1:A4,1) = LARGE(A1:A4,2) =
LARGE(A1:A4,3)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Smint" wrote in message
...
How would I be able to pull 3 of the largest numbers in a list of 4
numbers
and list them in their own cells right next them.
IE.
100 100
80 80
20 70
70

Where the smallest number is left out but the three highest are
displayed.
Thanks