Find number date combo once...

**maxthebear** · 07-11-2009, 03:10 PM

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** · 07-11-2009, 03:39 PM

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.

F8: =IF(ISERROR(MATCH(D8&"_"&E8,INDEX($D$7:$D7&"_"&$E$7:$E7,0),0)),1,"")

Copy that formula down through F14

These are the returned values:

Number  Date         Formula
8       02/08/2009      1
8       02/08/2009
8       02/27/2009      1
6       02/27/2009      1
6       02/27/2009	
5       03/05/2009      1
5       03/06/2009      1

Does that help?

**maxthebear** · 07-11-2009, 03:49 PM

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