I have a list of formulae for about 2000 products. In the table the Product
Name repeats and in the rows to the right of the name are the ingredients. I
can group the data by product, leaving "x" number of blank rows to separate
one column from another.

In that 2000 products, I have maybe 8 that use the same ingredient twice;
once near the beginning, once near the end. I want to be able to identify
those 8 products.

I need some way to consider each product as a discreet group and then
evaluate that group, looking for repeats in the ingredients column. Then I
need someway to highlight or otherwise bring products of this type to my
attention.

Just in case the above was too murky, here's and example of what I'm
looking for:

Product A Step 1 Ingredient-1000
Product A Step 2 Ingredient-8000
Product A Step 3 Ingredient-9000
Product A Step 4 Ingredient-1000
Product A Step 5 Ingredient-2000

I want to spot the two additions of ingredient-1000 (in steps 1 and 4). Can
this be done? Can it be done forcing the macro (or logical argument) to
consider a single grouping of ingredients, a single product, at a time?

Thanks