OK...Let's try this again. Not sure if the forum editor misread a formula or if I had a hardware problem (a loose nut in front of my keyboard)
Note: These are all regular formulas...NOT array-formulas.
Using your posted workbook, I used helper columns to keep the formulas understandable.
These formulas, copied down, set up the items to be counted:
Concatenate the values
Identify duplicates
This formula, copied across and down through L11, fills in the duplicate records
And this formula, copied down, returns the row number of the duplicate
Is that something you can work with?
Bookmarks