Lookup data in previous cells

**maddog9486** · 09-01-2011, 08:22 AM

I am trying to deretemine in someone is a repeat caller.

Not sure if this is possible or not, but i'm looking for a way to do a lookup using one cell but want it to only do the look up in the cells before it not after it, but at the same time not count the first appearance as a repeat call.

Example:
Column A contains a list of names
Column B will contain the said formula with the result returning "Yes" or "No"

So lets say the name "John Smith" is listed in cell A2, A5 and A10. In cell A2, the fomula would return a "No", because this is the first appearance of the name John Smith, therefore he's not a repeat caller.

In cell A5, the formula would lookup John Smith in the cells before it (A2:A4), but this time it would see John Smith in A2 therefore return "Yes". Same would apply for cell A10.

I have attached a file as an example as well.