You know one way you can do that without a macro or an easier macro, you can
highlight the entire column with BANGOR ME and BATON ROUGE, then hit CTRL+G.
Go to Special. Click on Blanks. Then right click on one of the blanks, hit
delete shift upwards

"rjreilly" wrote:

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!