| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find empty cells, fill with text from cell above
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find empty cells, fill with text from cell above
Hi Marketer
See http://www.contextures.com/xlDataEntry02.html -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Marketer" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Fill empty cells | Excel Worksheet Functions | |||
| Macro Request: Fill in empty cells with previous Filled cell in column | Excel Worksheet Functions | |||
| I need to fill only empty cells in a database with a symbol. | Excel Discussion (Misc queries) | |||
| fill cell value to the next empty row | Excel Discussion (Misc queries) | |||
| Fill-in empty cells from SAP report | Excel Worksheet Functions | |||
Hybrid Mode
