How do I copy data from one cell to the next occurrence of data?

E

excelmad

I have a very large file in which I need to copy the SSN down to the point
where the next SSN begins. How can I accomplish this task?

I have information in a worksheet as follows:

SocialSec # Acct Bal Type Amount
Row1 SSN Account BalA 50.00
Row2 Account BalC 100.00
Row3 Account BalD 250.00
Row4 SSN #2 Account BalA 50.00
Row5 Account BalC 14.00
Row6 Account BalD 75.50
Row7 Account BalE 35.00
Row8 SSN #3 Account BalA 22.00
Row9 Account BalB 25.00
 
D

Duke Carey

Insert a temporary column to the left of your SSNs
Assuming your SSns are in col B (after the insert) and start in row 2, use
this formula in A2, and copy it down.

Do this on a copy of your data

=IF(ISBLANK(B2),A1,B2)

After copying it down all the way, select all the formulas, copy them,
select the cells with the original SSNs, and use Edit->Paste Special->Values
 
K

Kevin Vaughn

I like this method which I copied from a post here, but have also seen in a
John Walkenbach book:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.
 
E

excelmad

Thank you so much...it worked perfectly.

Duke Carey said:
Insert a temporary column to the left of your SSNs
Assuming your SSns are in col B (after the insert) and start in row 2, use
this formula in A2, and copy it down.

Do this on a copy of your data

=IF(ISBLANK(B2),A1,B2)

After copying it down all the way, select all the formulas, copy them,
select the cells with the original SSNs, and use Edit->Paste Special->Values
 
E

excelmad

This works awesome too. Thank you.

Kevin Vaughn said:
I like this method which I copied from a post here, but have also seen in a
John Walkenbach book:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top