Lookup in one column
 

Hi there,

I havent used Microsft Excel for a few years now so I'm pretty rusty on
the basics.

What I would like to know is whether it is possible to do a lookup on a
column to see if there is more than one cell with the same contents?

For example I have input 1000+ Id's into column A and what to know if
there are any duplicates.

Thanks in advance if you can help me!


--
petercummins
------------------------------------------------------------------------
petercummins's Profile: http://www.excelforum.com/member.php...o&userid=37879
View this thread: http://www.excelforum.com/showthread...hreadid=574207

Lookup in one column
 

In column B:

=IF(COUNTIF($A$1:$A$1000,A1)1,"Duplicate","")

and copy down.

HTH

"petercummins" wrote:


Hi there,

I havent used Microsft Excel for a few years now so I'm pretty rusty on
the basics.

What I would like to know is whether it is possible to do a lookup on a
column to see if there is more than one cell with the same contents?

For example I have input 1000+ Id's into column A and what to know if
there are any duplicates.

Thanks in advance if you can help me!


--
petercummins
------------------------------------------------------------------------
petercummins's Profile: http://www.excelforum.com/member.php...o&userid=37879
View this thread: http://www.excelforum.com/showthread...hreadid=574207

Lookup in one column
 

you really are top! Nice work thanks!


--
petercummins
------------------------------------------------------------------------
petercummins's Profile: http://www.excelforum.com/member.php...o&userid=37879
View this thread: http://www.excelforum.com/showthread...hreadid=574207