Find empty cells, fill with text from cell above

G

Guest

I have a spreadsheet where not every row is filled in first column. for
example, column 1 is customer name, column 2 is sales category, column 3 is
the customer sales for that category. A customer that purchased in 3
categories, only has the company name on the first record. So, the records
with no company name...are actually records for the same company above it.

I'm trying to figure out a way to search all cells in column 1, and if the
cell is empty, populate it with the text from the cell above it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to fill in names in cells automatically 2
Excel - Fill empty cells 3
Subtotal Function - add formula to all blank rows 1
Trying to run excel vba code when cell value changes from empty to entered value. 1
Counting Unique occurences of text in a column 12
Create New Table/Column 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Filling empty cell with value from the cell above 2

Top