Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function do I use?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function do I use?
=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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function do I use?
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 -- I started with nothing and I still have most of it left "Bob Phillips" wrote: =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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function do I use?
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. -- I started with nothing and I still have most of it left "Bob Phillips" wrote: =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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Which function do I use?
B$2:B$250
Look in Excel help for absolute and relative addressing. -- David Biddulph "Denzoid" wrote in message ... 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. -- I started with nothing and I still have most of it left "Bob Phillips" wrote: =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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |