Fill Excel Cell Formula

[camster39]

Using Excel 2002:

Column A Column B Column C Column D

11111 9-15-95 Manager $50,000
10-20-80 Supervisor $40,000
11-10-70 Labor $30,000

An example of a spreadsheet where an employee has multiple historical records. All I want to do is populate column A with the data of the row above it. In the above example, the second and third rows do not have a value in column A - I want to populate column A with 11111 & 11111 for both rows, so it looks like this.

Column A Column B Column C Column D

11111 9-15-95 Manager $50,000
11111 10-20-80 Supervisor $40,000
11111 11-10-70 Labor $30,000

I've got about 7,000 rows so I am looking for some kind of a forumla to populate column A cells if there is a blank value in the cell.

Thank you.

 

[ETID]

insert a column to the left of A....

then in row 2 of new col A...(assuming a header in row 1)


=IF(B2="",A1,B2)

fill down

copy and paste special > values over old col A

 

[ETID]

Insert a column to the left of A....

then in row 2 of new col A...(assuming a header in row 1)

=IF(B2="",A1,B2)

fill down

copy and paste special > values over old col A

 

[ETID]

Oooops ,...slow server today

 

[camster39]

Thanks much - worked perfectly.

 

[KenWright]

No need for extra columns:-

Assuming A2:A100 is your range, select it and do edit / Go To / Special / Blanks. Type = and then hit the UP arrow once. Now just hit CTRL+ENTER.

Also detailed in the FAQs:-

faq68-4741
How to fill in the blanks in a list of data.

Regards
Ken...........

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

----------------------------------------------------------------------------