How do I auto fill blanks cells immediately below with the same i.
I have an xllss with 1000 rows and in column "A" is the customer name. In
many cases the customer name has blanks below it before a new customer name appears. I need a formula that will automatically fill in the customer name above but be smart enought to recognize a new customer name and then fill in that name in the blank cells below it. in the example i need to auto fill abc in row 2 and def in row 4. customer 1 abc 2 3 def 4 |
Take a look at how Debra Dalgleish describes it at:
http://www.contextures.com/xlDataEntry02.html#Fill leo wrote: I have an xllss with 1000 rows and in column "A" is the customer name. In many cases the customer name has blanks below it before a new customer name appears. I need a formula that will automatically fill in the customer name above but be smart enought to recognize a new customer name and then fill in that name in the blank cells below it. in the example i need to auto fill abc in row 2 and def in row 4. customer 1 abc 2 3 def 4 -- Dave Peterson |
Worked like a charm. thank you, leo
"leo" wrote: I have an xllss with 1000 rows and in column "A" is the customer name. In many cases the customer name has blanks below it before a new customer name appears. I need a formula that will automatically fill in the customer name above but be smart enought to recognize a new customer name and then fill in that name in the blank cells below it. in the example i need to auto fill abc in row 2 and def in row 4. customer 1 abc 2 3 def 4 |
All times are GMT +1. The time now is 04:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com