| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Getting the top 5
I have 48 percentage entries in one row. In the next row, I would like to
list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
I suuspect you want to use the RANK function for thatRon;186631 Wrote: I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51507 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Simon Lloyd;186633 Wrote: I suuspect you want to use the RANK function for thatSorry, i meant to give you this link 'Ranking Data In Lists' (http://www.cpearson.com/excel/Rank.aspx) it's Chip pearsons site and has a cery well explained section on the use of rank! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51507 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Thanks Simon, I get a #VALUE error when I try this. Could the kind of data be
the problem? "Simon Lloyd" wrote: Simon Lloyd;186633 Wrote: I suuspect you want to use the RANK function for thatSorry, i meant to give you this link 'Ranking Data In Lists' (http://www.cpearson.com/excel/Rank.aspx) it's Chip pearsons site and has a cery well explained section on the use of rank! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51507 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Say your values are in A1 to AV1.
Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5
in B1 to B5. Now what do I do? "Ragdyer" wrote: Say your values are in A1 to AV1. Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Enter in B1:
=LARGE(A$1:A$25,ROWS($1:1)) And copy down. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5 in B1 to B5. Now what do I do? "Ragdyer" wrote: Say your values are in A1 to AV1. Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
PERFECT! Thank you for the expounded explanation. It works just the way I had
hoped. Ron "Ragdyer" wrote: Enter in B1: =LARGE(A$1:A$25,ROWS($1:1)) And copy down. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5 in B1 to B5. Now what do I do? "Ragdyer" wrote: Say your values are in A1 to AV1. Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
You're very welcome, and appreciate the feed-back ... although I didn't
think that I explained anything, much less elaborated it enough to have it labeled as an expounded explanation.<bg -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... PERFECT! Thank you for the expounded explanation. It works just the way I had hoped. Ron "Ragdyer" wrote: Enter in B1: =LARGE(A$1:A$25,ROWS($1:1)) And copy down. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron" wrote in message ... Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5 in B1 to B5. Now what do I do? "Ragdyer" wrote: Say your values are in A1 to AV1. Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Getting the top 5
Based on the location of your data and formulas, this is a shorter solution:
=LARGE(A$1:A$25,ROW()) ROW() return the row number of the formula, in this case 1 in B1. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Ron" wrote: PERFECT! Thank you for the expounded explanation. It works just the way I had hoped. Ron "Ragdyer" wrote: Enter in B1: =LARGE(A$1:A$25,ROWS($1:1)) And copy down. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron" wrote in message ... Thanks Ragdyer. Say my values are in A1 to A25. Now I want to list the top 5 in B1 to B5. Now what do I do? "Ragdyer" wrote: Say your values are in A1 to AV1. Enter this formula anywhere, and copy across as many columns as you wish to see results: =LARGE($A$1:$AV$1,COLUMNS($A:A)) -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "Ron" wrote in message ... I have 48 percentage entries in one row. In the next row, I would like to list the top 5 percentages. It doesn't matter if some are the same percentage. Can someone help me please? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
