Which function do I use?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denzoid - 07 May 2008 07:16 GMT

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

Signature

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

Reply to this Message

Bob Phillips - 07 May 2008 09:09 GMT

=MATCH(order_num,list_of_nums,0)

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

Signature

HTH

Bob

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

>I have long lists of orders which I can easily sort but what I would like
>to
[quoted text clipped - 4 lines]
>
> Cheers

Reply to this Message

Denzoid - 08 May 2008 08:29 GMT

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

Signature

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

> =MATCH(order_num,list_of_nums,0)
>
[quoted text clipped - 8 lines]
> >
> > Cheers

Reply to this Message

Denzoid - 08 May 2008 08:32 GMT

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.

Signature

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

> =MATCH(order_num,list_of_nums,0)
>
[quoted text clipped - 8 lines]
> >
> > Cheers

Reply to this Message

David Biddulph - 08 May 2008 09:13 GMT

B$2:B$250
Look in Excel help for absolute and relative addressing.
--
David Biddulph

> 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
[quoted text clipped - 19 lines]
>> >
>> > Cheers

Reply to this Message