Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I get regular data runs contain 2 fields, product and date, where unique
combinations thereof amount to batches. the dates can and do change. Products can move on and off the list. I am looking for a solution to review the the 2 arrays and determine the numver of unique combinations and based on chronoligical order of date past to future return the name of the product and a batch number. "Apples 2" would be the second of unique combinations of product Apples and date. There may be 2 there may be 20 combinations, depending on any individual datra run. And where Product appears without a date I am looking for Product name followed by "unscheduled" instead of a batch number (foe example; "Apples Unscheduled"). "Pears 1" would be the first or unique combination for product Pears. Thank you in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logic question | Excel Worksheet Functions | |||
Check box logic question | Excel Worksheet Functions | |||
IF(?) logic question | Excel Discussion (Misc queries) | |||
Count logic question | Excel Discussion (Misc queries) | |||
Logic question | Excel Discussion (Misc queries) |