vzachin
01-25-2008, 07:12 AM
hi,
i have 2 columns of data about 1000 entries.
Column B contains original data, Column E contains new data.
i want to compare the 2 columns and extract the differences and placing the data into the adjacent column but not in the same row.
i'm currently using the following formula and filling down
=IF(ISBLANK(B5),"",IF(COUNTIF($E$5:$E$20,B5),"", B5))
how can i code this in vba? without placing the formulas and placing the differences in the adjacent column but not adjacent row (just list the differences)?
thanks
zach
i have 2 columns of data about 1000 entries.
Column B contains original data, Column E contains new data.
i want to compare the 2 columns and extract the differences and placing the data into the adjacent column but not in the same row.
i'm currently using the following formula and filling down
=IF(ISBLANK(B5),"",IF(COUNTIF($E$5:$E$20,B5),"", B5))
how can i code this in vba? without placing the formulas and placing the differences in the adjacent column but not adjacent row (just list the differences)?
thanks
zach