Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |