I want find duplicates entry after first entry in list b from list a

**breadwinner** · 07-11-2013, 02:18 PM

I have value in two column column a contans some value towards b column
a 11
a 11
a 12 new entry - a
b 22
b 23 new entry b
b 24 new entry b

first entry value consider as new entry any new values enter consider as new entry with value of lookup.

Please find the attachment

**extremis** · 07-11-2013, 02:24 PM

hi..sorry, what do you try to acheive exaclty?

**FDibbins** · 07-11-2013, 05:47 PM

I used D so that you can compare with what you had, but you can put this in C if you want, after you test it. copy down...

=IF(B2="","",IF(A2=A1,IF(B2=B1,"","New Entry - "&A2),""))