Fill in blank cells.

[kaleb0521]

I receive a data feed that is converted in Excel. The sheets average
about 24000 rows. I receive an ID in column A and Price Amt in column
C, BUT the data leaves proceeding rows blank until the next new ID
starts. I need to fill in those blanks with the ID above. I have tried
an IF function in an adjacent cell but it is not functioning properly.


Example Data:
A B
09.TXNU.355331..GTES 18.69
9.43
8.09
47.25
10.50
62.50
09.TXNU.360891..GTES 18.69
9.43
47.25
10.50
62.50
09.TXNU.360892..GTES 9.43
10.50
09.TXNU.360893..GTES 9.43
10.50



Thank you. Kaleb

 

[Peo Sjoblom]

Select the the ID range, press F5, click special, select blanks, type =
press up arrow

press ctrl + enter.

Done..

 

[Ken Wright]

May also then want to copy ID range and paste special as values to get rid of
the formulas - just in case you sort your data at all.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

Select the the ID range, press F5, click special, select blanks, type =
press up arrow

press ctrl + enter.

Done..