Larger Number

[smandula]

Need help with function ' Large '. When
=LARGE($C$8:$C$77,1)
=LARGE($C$8:$C$77,2)
is copied to separate cells, ' Large ' stops or
indentifies the first number of group that has
indentical numbers (36 36).


Freq Number
40 29
38 43
37 7
36 20
36 20
35 13


such as 36 and 20 in the above.
How do you go past the first number 20, to the
second number Freq (36), which in this case would be 58.

With Thanks

 

[smandula]

I forgot to add, that I use a Lookup

=VLOOKUP(K25,C877,2,FALSE)
to obtain the number 20.
It is here where the second number is stuck.

Hope this explanation helps.

Thanks

 

[Tom Ogilvy]

You are correct. The Lookup functions do not find duplicate entries.

You would probably need to use an array formula but this is usually a
formula designed specifically for the functionality required.

You would need to be specific about what you are trying to achieve and how
your data is laid out.