Formula for the Top 3...

[AndrewKent]

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

 

[VoG]

Try

=LARGE($A1:$J1,1)

=LARGE($A1:$J1,2)

=LARGE($A1:$J1,3)

 

[jim may]

Had to DROP one Column as HTML Maker software limit column pasting to 12 columns.. Hope this helps... Jim

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1
2	10.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
Range	Formula
J2	=LARGE($A2:$I2,1)
K2	=LARGE($A2:$I2,2)
L2	=LARGE($A2:$I2,3)

 

[AndrewKent]

Thanks guys, works a charm.