Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto fill box | Excel Discussion (Misc queries) | |||
Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) |