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

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



"excelmad" wrote:

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

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.

--
Kevin Vaughn


"excelmad" wrote:

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

Thank you so much...it worked perfectly.

"Duke Carey" wrote:

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



"excelmad" wrote:

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

This works awesome too. Thank you.

"Kevin Vaughn" wrote:

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.

--
Kevin Vaughn


"excelmad" wrote:

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

You're welcome.
--
Kevin Vaughn


"excelmad" wrote:

This works awesome too. Thank you.

"Kevin Vaughn" wrote:

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.

--
Kevin Vaughn


"excelmad" wrote:

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