Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,123
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Fill empty cells Yendorian Excel Worksheet Functions 3 July 23rd 07 09:34 AM
Macro Request: Fill in empty cells with previous Filled cell in column Artis Excel Worksheet Functions 2 June 25th 07 08:30 PM
I need to fill only empty cells in a database with a symbol. SMC Excel Discussion (Misc queries) 2 April 24th 07 04:28 PM
fill cell value to the next empty row adey v. Excel Discussion (Misc queries) 2 November 15th 05 02:47 AM
Fill-in empty cells from SAP report Ilieski Excel Worksheet Functions 3 September 14th 05 12:55 PM


All times are GMT +1. The time now is 06:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"