Find number date combo once...

[maxthebear]

I had a partial answer but cannot get the rest of this to work.

I am trying to put a 1 in a cell whenever you find a unique number and date. If you find the same number and date combination, ignore it after the first one. I have attached a file that better explains the problem. thanks again...

Max

[Ron Coderre]

I'm not sure your example shows the desired values, based on your description.

Here's what my posted formula does:
Returns 1 whenever the same number/date combination does not appear prior to the current instance.

Please Login or Register  to view this content.

Copy that formula down through F14

These are the returned values:

Please Login or Register  to view this content.

Does that help?

[maxthebear]

Works perfectly. I really do appreciate your help on this. I had part of it but couldn't handle 2 variables. Again, thanks and another solved..........

Max