jphleung
09-16-2008, 08:49 PM
Hi all,
I currently would like to do the following: there are two columns of numbers (it can be up to 25000 numbers in a column). Name the two columns ColA and ColB. I would like to delete the numbers that have appeared in ColA from ColB.
E.g. ColA: 2,4,6,8
ColB: 1,2,3,4,5,6,7,8,9,0
I would like to have the code to return ColB as 1,3,5,7,9,0. I have found a few code for similar problem, but they dont really solve mine. Please help me the code, I am very appreciate about it.
Jeff
I currently would like to do the following: there are two columns of numbers (it can be up to 25000 numbers in a column). Name the two columns ColA and ColB. I would like to delete the numbers that have appeared in ColA from ColB.
E.g. ColA: 2,4,6,8
ColB: 1,2,3,4,5,6,7,8,9,0
I would like to have the code to return ColB as 1,3,5,7,9,0. I have found a few code for similar problem, but they dont really solve mine. Please help me the code, I am very appreciate about it.
Jeff