Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multipy group of numbers | Excel Discussion (Misc queries) | |||
How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Working with a large group of numbers | Excel Worksheet Functions |