Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete items from a column
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete items from a column
more info needed. What is in col A., what is in col B
-- Don Guillett SalesAid Software "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete items from a column
column a is part numbers like 797553001151, 797553005157... (each unique), column B is sold items of column A, so the numbers will be the same. So i need whatever is in both column A and B NOT to be in Column C
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete items from a column
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
Cannot Delete Items in a Cell | Excel Discussion (Misc queries) | |||
line up items in column a with items in columns b, c, etc | Excel Discussion (Misc queries) | |||
delete items | Excel Discussion (Misc queries) | |||
SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions |