Which function do I use?

  • Thread starter Thread starter Denzoid
  • Start date Start date
D

Denzoid

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
 
=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)
 
It probably will if I can fix the array.
I inserted the function to order b2 in the array b2:b250 but when I copied
this to b3 the array moved to b3:b251 and so on.
If I can get the array to stay the same I could be getting somewhere.

Thanks for your reply anyway
 
It may do if I can fix the array.
I wrote the function to order b2 in the array b2:b250 but when I copied the
function to b3 the array moved to b3:b251 and so on.
If I can fix the array at b2:b250 without typing each cell I might be
getting somewhere.

Thanks for your help it has at least pointed me in the right direction.
 
Back
Top