Fill in blank cells.

  • Thread starter Thread starter kaleb0521
  • Start date Start date
K

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
 
Select the the ID range, press F5, click special, select blanks, type =
press up arrow

press ctrl + enter.

Done..
 
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 :-)
----------------------------------------------------------------------------



Peo Sjoblom said:
Select the the ID range, press F5, click special, select blanks, type =
press up arrow

press ctrl + enter.

Done..
Click to expand...
 
Back
Top