Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I looked through the boards, came close to finding what I needed... but they
were off a little. I have ColA and ColB filled to about 30000 Rows. I would like a script that compares each column, and inserts a/some rows if they dont match up. The blank column could be inserted on either column and if there is 20 rows of missing data, it inserts 20 rows of blanks. Ex: The script would Befo Col1 Col2 1 1 2 2 3 4 4 5 5 6 7 10 After: Col1 Col2 1 1 2 2 3 4 4 5 5 6 7 10 Is this possible? Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compare data in two columns | Excel Worksheet Functions | |||
Compare data in two columns | Excel Worksheet Functions | |||
compare data from 2 columns | Excel Worksheet Functions | |||
Need to compare data in 2 columns and not sure how. | Charts and Charting in Excel | |||
Trying to compare data in two columns... | Excel Worksheet Functions |