Whitebull said:
will this formula work in a single column or multiple columns or both?
Which?
The one in col D in Sheet1?
(It's a helper formula for Sheet2's formulas to read)
The formula is to be placed in a single column,
and will "flag" unique items in the Artist & Song in cols A and B
As posted earlier, the source table in Sheet1 was assumed:
Col A = Artist, col B = Song, data from row2 down
