Appreciate you acting as my lawyer.<vbg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"BenjieLop" wrote
in message ...[color=blue]

Hi Duke,

I am not offering or commenting on a solution that *"people often want
to mark ALL entries that are dupes."* What people often want is not
what the OP was asking here.

Paul was specifically looking for a solution to identify the third
entry as there are *"only two allowed."*


Regards.



Duke Carey Wrote:[color=green]
Will work...if you only want to mark the 3rd occurrence. People often
want
to mark ALL entries that are dupes, to allow them to determine which to
keep
and which to purge...

"BenjieLop" wrote:


RD's suggested formula

*=IF(COUNTIF($A$2:A2,A2)2,"Dup","Ok")*

will work. The third time the same name is entered in Column A, the
immediate cell to its right (in Column B) will show "Dup" ...





Duke Carey Wrote:
Hmmm. Don't think that works, either

Maybe:

=IF(COUNTIF($A$20:A2,A2)2,"Dup","Ok")


"RagDyeR" wrote:

Believe you have a typo?!?!

=IF(COUNTIF($A$2:A2,A2)2,"Dup","Ok")

--

Regards,

RD



--------------------------------------------------------------------------
--[color=darkred]


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile:
http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=394615