LARGE

[ArturoCohen]

Hello everyone,

can i make "large" to return to me both numbers when they are the same
value. example:
A1- 50
A2- 68
A3- 98
A4- 101
A5- 68
....

i use LARGE to get the top three, but when i got two or more with the
same value i want those too. so in this case i want to have in return:
value 1 = 101
value 2 = 98
value 3 = 68 (from cell a2)
value 4 = 68 (from cell a5)
(i dont care about the order of the last two)

thanks

 

[Don Guillett]

http://tinyurl.com/f6zwq

 

[ArturoCohen]

Thanks man!

got some new learning too.

Arturo

 

[Don Guillett]

glad to help