# How to define a formula (calc) for: If A1 is exactly found in at least one cell in the range from B1 to B100?

Here is the cell array C:\fakepath\get2rowswithoutduplicates.png

Why do you skip first "t" in column A?

Hi JohnSUN, what "Y"?

In your screenshot I see "t" in cells A2 and A4. Second value is striked, but first - in cell A2 - not striked

Ah. OK, forget all t in the first column as I erased this type of entries in the meantime. Sorry for my reading mistake (t as Y) ..