Ignore Duplicates
Assuming range starts from cell A1 downwards.
In cell B1 enter this formula and drag down
=IF(OR(A1="",COUNTIF(INDIRECT(ADDRESS(ROW($A$1),COLUMN($A$1))&":"&ADDRESS(ROW(),COLUMN()-1)),A1)>1),"",A1)
© Copyright
andrewsexceltips.net
All Rights Reserved.