=MATCH(order_num,list_of_nums,0)

will return the index number of that order. Does that get you anywhere?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Denzoid" wrote in message
...
I have long lists of orders which I can easily sort but what I would like
to
do next is choose a column (e.g. order number) and have just the first
occurrence of each number returned.
Everyone here seems to think that they know how to do this but no one has
got as far as proving it yet.

Cheers
--
I started with nothing and I still have most of it left