simple excel formula

[jewilson2]

Hello all.

I am trying to fill in records in a column via a formula. Basically, the spreadsheet was created from a text import that contained header records. I want to repeat that header value for each detail line, then when the header value changes, fill it in the next section. I've done this before but cannot remember for the life of me the formula.

60000057 100
110
300
310
360
370
470
984
60000128 10
15
40
100
110
255

so basically i want to fill down column a with the 6000### value until that value changes, the change/fill the new value. I did this before by inserting a column between the 2, copying column a into column b and doing if/then statements on A and B to compare and fill down.

Does this make sense at all?

 

[SkipVought]

Hi,

Assuming that you list begins in A1, in C1...
[tt]
=A1
[/tt]
In c2 and copy down
[tt]
=if(isblank(a2),c2,a2)
[/tt]
Then Copy column C and PasteSpecial - Values into column A.

Delete column c

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[SkipVought]

sorry,

in c2 and copy down...
[tt]
=if(isblank(a2),c1,a2)
[/tt]


Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[00112233]

=if(isblank(a2),c1,a2) does this equels to:

if a2 is blank then c1 else a2?

Thanks



Beautiful British Columbia

http://www.vancouverfinder.org/

- Your Vancouver Guide