anmlhse
05-11-2011, 02:13 PM
Hello to all!
I need to write a macro that will insert a 0 (zero) in column B on a new blank line, when column A has a 1, and then followed by another 1, or number. The data was given with a comma after the number. Also the zero in "data to be expected" should be in Column B and not A. Sorry about that.
Current data:
1, 575011787
1, 575011788
1, 575011789
2, 575011790
3, 575011791
4, 575011792
1, 575011793
2, 575011794
1, 575011795
Data to be expected:
1, 575011787
0
1, 575011788
0
1, 575011789
2, 575011790
3, 575011791
4, 575011792
0
1, 575011793
2, 575011794
0
1, 575011795
0
Does this make sense? Not sure if this can even be done. It's given me way to many headaches in thinking of a solution. Any help is greatly appreciated. Thank You!
I need to write a macro that will insert a 0 (zero) in column B on a new blank line, when column A has a 1, and then followed by another 1, or number. The data was given with a comma after the number. Also the zero in "data to be expected" should be in Column B and not A. Sorry about that.
Current data:
1, 575011787
1, 575011788
1, 575011789
2, 575011790
3, 575011791
4, 575011792
1, 575011793
2, 575011794
1, 575011795
Data to be expected:
1, 575011787
0
1, 575011788
0
1, 575011789
2, 575011790
3, 575011791
4, 575011792
0
1, 575011793
2, 575011794
0
1, 575011795
0
Does this make sense? Not sure if this can even be done. It's given me way to many headaches in thinking of a solution. Any help is greatly appreciated. Thank You!