Thread: Large function
View Single Post
  #1   Report Post  
Sandy
 
Posts: n/a
Default Large function

Hi Group
I am trying to find the top 10 values in a range. If a value is repeated
then it may show up say as the largest and next largest. How do I ignore
repeated values.

20
20
19
19
2
12
15
5
6
19

large(A1,A10,1)=20
large(A1,A10,2)=20
large(A1,A10,3)=19
large(A1,A10,4)=19
large(A1,A10,5)=19
etc
I would like to return
largest = 20
next largest =19
next largest =15
etc.

Thanks!