Selective Filling ?

[Alunn]

Excel 2002 WINXP

JC01 Comparison.xls
	B	C	D	E
8098	607		Xz chamber lifter lift - release traveling distance
8099		ChA	Xz chamber lifter lift - release traveling distance	420
8100		ChB	Xz chamber lifter lift - release traveling distance	420
8101		ChC	Xz chamber lifter lift - release traveling distance	420
8102		ChD	Xz chamber lifter lift - release traveling distance	420
8103		ChE	Xz chamber lifter lift - release traveling distance	420
8104		ChF	Xz chamber lifter lift - release traveling distance	420
8105		Ch1	Xz chamber lifter lift - release traveling distance	420
8106		Ch2	Xz chamber lifter lift - release traveling distance	420
8107		Ch3	Xz chamber lifter lift - release traveling distance	420
8108		Ch4	Xz chamber lifter lift - release traveling distance	420
8109		Ch5	Xz chamber lifter lift - release traveling distance	420
8110	608		Chamber target pm trig target life warning trigger
8111		ChA	Chamber target pm trig target life warning trigger	80
8112		ChB	Chamber target pm trig target life warning trigger	80
8113		ChC	Chamber target pm trig target life warning trigger	80
8114		ChD	Chamber target pm trig target life warning trigger	99
8115		ChE	Chamber target pm trig target life warning trigger	80
8116		ChF	Chamber target pm trig target life warning trigger	80
8117		Ch1	Chamber target pm trig target life warning trigger	99
8118		Ch2	Chamber target pm trig target life warning trigger	99
8119		Ch3	Chamber target pm trig target life warning trigger	99
8120		Ch4	Chamber target pm trig target life warning trigger	99
8121		Ch5	Chamber target pm trig target life warning trigger	99
Sheet1

I am trying to fill the blanks in Column B with the last Value ie rows 8099 to 8109 would be filled with 607 Rows 8111 to 8121 would be filled with a value of 608. The number of cells that are blank and the spacing between them are not constants. Any Ideas?

 

[Norie]

Select column B and then goto Edit>Goto...>Special... and pick blanks.

Then enter = and press the up key in the formula bar then press CTRL+ENTER.

 

[Alunn]

Selective Filling

Norie thanks alot for the quick response.

I used the GoTo Special , chose the blank option , all of the Blanks in hte column are now highlighted.
I go to the formula bar and it takes the "=" ok , but won't take the up, I also tried CNTL+UP and END+UP it won't thake those either when I hit the CNTL+ENTER it fills the blanks with "="

Any suggestions?

Al

 

[Norie]

Well select the first cell of data in the column, B8098 in your example.

 

[Alunn]

Selective Filling

=B$8098

I set the value as above and it populated all of the blanks with the value "607", I need it to populate with the last value above that particular blank cell.

Sorry to be pain and thanks again Al

 

[Norie]

Al

This method definitely works.

Why have you set an absolute reference to row 8098?

=B8098

 

[Alunn]

Norie, I had three header rows at the top of the column Two contained blanks, It was throwing off the Reference. I copied the column to a new sheet deleted the header rows and tried it again and it worked thanks, you are a godsend. Al

 

[Alunn]

PS I had 560,000 lines to do Thanks again.

 

[Norie]

PS I had 560,000 lines to do Thanks again.

In Excel?