Hi
no need for a macro. enter the following in B1
=IF(COUNTIF($C:$C,A1)0,0,"")
and copy down
you may have a look at
http://www.cpearson.com/excel/duplic...gingDuplicates
and
http://www.cpearson.com/excel/duplic...tractingCommon
for more information

--
Regards
Frank Kabel
Frankfurt, Germany

I'm trying to update the stock level with a macro all at one time by
say comparing column C with column A and if there is a match put the
number 0 in the next cell in column B it would have to be the next
cell to A in order to match up with the original records. Also,
column C comparing to column A will most likely be in a different
row.

ex.

column A..........column B...........column C

ame-4play.................................gmn-pl101
tos-sdv280..............................gmn-gsm15
gmn-gsm15..........0..................jvc-kds690


Thank you for your time,

Greg


---
Message posted from http://www.ExcelForum.com/