W Whitebull Nov 15, 2004 #1 will this formula work in a single column or multiple columns or both? fre
M Max Nov 15, 2004 #2 Whitebull said: will this formula work in a single column or multiple columns or both? Click to expand... 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
Whitebull said: will this formula work in a single column or multiple columns or both? Click to expand... 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