kdoubles
07-31-2003, 07:46 AM
This is more of a macro question but here it goes....I can use either excel or quattro pro. I have a column of numbers orderer like so:
12
0
0
34
0
0
0
65
0
0
What I want the macro to do is go down the column and when it hits a non zero value store it, and when it hits a zero it will replace it with the last non zero value stored. So it would look like this when done.
12
12
12
34
34
34
34
65
65
65
The column I have has over 16000 entries, so manually it will take a while! Thanks for any help!!!!
12
0
0
34
0
0
0
65
0
0
What I want the macro to do is go down the column and when it hits a non zero value store it, and when it hits a zero it will replace it with the last non zero value stored. So it would look like this when done.
12
12
12
34
34
34
34
65
65
65
The column I have has over 16000 entries, so manually it will take a while! Thanks for any help!!!!