Based on column numbers? As in your data spans columns not rows? If, for example, your data (I'm assuming numerical) starts in A1 and goes across columns (as in B1, C1, etc.), you can try this in A2:
and drag across.![]()
=IF(COUNTIF($A$1:A1,A1)=1,1,"")
Bookmarks