Hello,

I have a list:

A1: Apple
B1: Orange
C1: Bannana
D1: Apple
E1: Mango
F1: Strawberry
G1: Peach
H1: Apple
etc

and I have an area where you can input values (like apple, orange, etc...) - this is in box C1:E4

Certain values, like Apple, show up more than once. I have a different list that goes like this:

=IF(COUNTIF($C$1:$E$4,A$1)>1," ", A1), and that's autofilled down for the entire fruit list. Basically, it turns repeated values into blanks.

Of course, inherently, it makes all repeated values blank. I want it to turn values blank only once per entry in the C1:E4 box

Thanks!