0 stock

[stiv]

I'm trying to update the stock level with a macro all at one time by sa
comparing column C with column A and if there is a match put the numbe
0 in the next cell in column B it would have to be the next cell to
in order to match up with the original records. Also, column
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,

Gre

 

[Frank Kabel]

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/duplicat.htm#TaggingDuplicates
and
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
for more information