Identifying Multiples

[z168]

I have this scenario...

I need to know how to flag when:

ID# visit date are same day or a day apart + Store Loc are different + Case are different

I may be asking too much from vlookups at this point

Thank in advance!ray:

 

[earthworm]

I have this scenario...

I need to know how to flag when:

ID# visit date are same day or a day apart + Store Loc are different + Case are different

I may be asking too much from vlookups at this point

Thank in advance!ray:

In the last column use this

assuming that your data starts from CELL A1

=IF(countif(A$1:A1,A1)>1,"Flag!","")

 

[z168]

Thank for the reply EarthWorm. and sorry for the late response. I was out of town for a week for some R&R

anyway, with the formula you gave, it only accounts for the repeats of the customer ID#. I need to be able to flag ONLY if:
1) ID#s are same
2) Dates are same
3) Stores are different

 

[T. Valko]

Thank for the reply EarthWorm. and sorry for the late response. I was out of town for a week for some R&R

anyway, with the formula you gave, it only accounts for the repeats of the customer ID#. I need to be able to flag ONLY if:
1) ID#s are same
2) Dates are same
3) Stores are different

Hmmm...

You're requirements are different from the initial post:

I need to know how to flag when:

ID# visit date are same day or a day apart + Store Loc are different + Case are different

Can you come up with definitive requirements?