copy down cells

[juliejg1]

I have a spreadsheet with column A and column B. B contains different
supplier names. Column A contains a region such as EU, NA, LA. However the
region is only in the first cell of the list it matches in column B. Just
like if I had created a pivot table from a list of data with region and
supplier. Each region would only show once because the suppliers are being
grouped by region. I need to be able to quickly copy down the region in
column A where there is a Region name above.

 

[teamschneller]

I have a spreadsheet with column A and column B.  B contains different
supplier names.  Column A contains a region such as EU, NA, LA.  However the
region is only in the first cell of the list it matches in column B.  Just
like if I had created a pivot table from a list of data with region and
supplier.  Each region would only show once because the suppliers are being
grouped by region.  I need to be able to quickly copy down the region in
column A where there is a Region name above.

You can use a simple if statement to do this. Create a new column
labeled the same as your Column A
=if(isblank(cellA3),CellB2,CellA3)

A B C
Row 1 Region Type Region
Row 2 a 1 a
Row 3 2 a
Formual in C3 and down "=IF(ISBLANK(A3),C2,A3)"

You will need to seed the first cell with the actual value of "A2".
Then you drag formula down, copy column, paste special over your
original column A, then delete the column you created.

 

[Tom Hutchins]

- Select the cells in the Region column (those with data and those that need
to be filled in).
- Select Edit >> Go to. Check the Blanks option, then click OK.
- Press = (the Equals key), then the Up arrow. Press Enter while holding
down the Ctrl key.
- Copy & paste in place as values.

Hope this helps,

Hutch

 

[juliejg1]

Thank you both for your response. Both ideas work!! Thanks again.