In C column I'd use this formula.
=IF(COUNTIF($B$2:$B$1000,A2)=0,A2)
And use headers for your column fields in row 1
A
VB option is overkill here, but if you must have one..
[C2:C1000].Formula = "=IF(COUNTIF($B$2:$B$1000,A2)=0,A2)"
Regards Robert
"Choice" wrote in message ...
I have a list A1:A1000, containing ALL products, in column B is the products returned. How would i go about in row C to have it
show the products left. Ive tried it with functions but cant get it right so i figured there has to be a way in VBA.
Thank you in advance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.659 / Virus Database: 423 - Release Date: 16/04/2004