D
Darin Kramer
Howdie...
Cells a1: a10 have numbers in them between 1 and 4
I want to know what the top 3 max numbers are
eg a1 = 3, a2 =3 a3 = 2 d3 to d10 = 0 then top 3 are 3, 3, 2
eg 2 if a1 = 3 and a2 to d 9 = 0 then only one max would be 3
eg if a1 = 2 b2 =2 c2 = 2 d1 = 1 c1 = 0, then top three max would be 2,
2 and 2.
ANy ideas...
(countif would work but seems to take a long time to write the formulae
to exclude the previous results....
Thanks
D
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Cells a1: a10 have numbers in them between 1 and 4
I want to know what the top 3 max numbers are
eg a1 = 3, a2 =3 a3 = 2 d3 to d10 = 0 then top 3 are 3, 3, 2
eg 2 if a1 = 3 and a2 to d 9 = 0 then only one max would be 3
eg if a1 = 2 b2 =2 c2 = 2 d1 = 1 c1 = 0, then top three max would be 2,
2 and 2.
ANy ideas...
(countif would work but seems to take a long time to write the formulae
to exclude the previous results....
Thanks
D
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!