Using the data you have listed, paste this function into C3.

=IF(AND(A3=A2,B3<B2),IF(B3<B1,"X","-"),"-")

Fill down to obtain your expected results.

However, there are several problems with this function:
1. If a "mistake" value is in the first row of a given account number, this
will not work
2. If you have two "mistake" values in consecutive rows, this will not work.

Tell me more about the function - Is b always the same, or does it change?
Do you need to know how many b's in 1, how many in 2, etc?
--
Anne Murray


"NPell" wrote:

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