Hello,

Im looking for a formula to filter data and see if it contains
something in another column.

IE:
A -- B -- C
1 -- a --
1 -- a --
1 -- b -- X
1 -- a --
2 -- c --
2 -- b -- X
2 -- c --
3 -- e --
3 -- e --
3 -- b -- X
3 -- e --
3 -- e --


So,
Account Number = "1" ... Name = "a" ... theres a "b" in there by
mistake (this is not a hidden value, i know what im looking for with
these "b"s) ... so an X is produced, or something, in column C.

It is also done for the "b" showing in a Account Number "2" and
Account Number "3"

Is there anything like VLOOKUP or COUNTIF, or something, maybe
combining the both - that could help?

Thanks