"Sandy Mann" wrote in message
...
"T. Valko" wrote in message
...
For something that's a little more eccentric:
=INDEX(FREQUENCY(A1:A20,{25,40}-{1,0}),2)
Very clever, well done.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
I think it was one of Ron Coderre's posts where I first saw that technique.
--
Biff
Microsoft Excel MVP