Dennis

To get a list without having to sort first, try this setup:


In e.g. D2
=Max(Rng)

In D3:
=LARGE(Rng,SUM(COUNTIF(Rng,$D$2:D2))+1)

D3 to be entered with <Shift<Ctrl<Enter, also if edited later.

Copy D3 down as far as necessary.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Dennis" skrev i en meddelelse
ups.com...
THANKS! :)