Formula for the Top 3...

AndrewKent

Well-known Member
Joined
Jul 26, 2006
Messages
889
Hi there,

I have 10 columns of % figures in one row. in the last three columns to the right of this I want to show the TOP 3 % figures. What fomrula should I use for this?

Andy
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

=LARGE($A1:$J1,1)

=LARGE($A1:$J1,2)

=LARGE($A1:$J1,3)
 

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,471
Had to DROP one Column as HTML Maker software limit column pasting to 12 columns.. Hope this helps... Jim
Excel Workbook
ABCDEFGHIJKL
1
210.0%15.0%8.0%56.0%31.0%91.0%87.0%75.0%65.0%91.0%87.0%75.0%
Sheet1
Excel 2007
Cell Formulas
RangeFormula
J2=LARGE($A2:$I2,1)
K2=LARGE($A2:$I2,2)
L2=LARGE($A2:$I2,3)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,203
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top