Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fill colum to the next non blank row
Ok,
Not sue how to explain this so I will just describe it: Here is an shortened sample of the file that I am working with: 1,New York, Joe Smith, AddressA 2,(null), Mary Joe, AddressB 3,(null), Jim Bob, AddressC 4,California, Billy Joel, AddressD 5,(null), Jane Doe, AddressE 6,(null), Mary Jane, AddressF What I need to do is fill the (null) cells with the title above it (so rows 2 & 3 should have New York in the (null) cell. Problem is there are hundreds of rows. Is there a way to fill a column so that the text "New York" is filled up only to the row that contains more text (in this case California, row 4)? -- --coastal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in the blank | Excel Discussion (Misc queries) | |||
colum 1 = product #'s than colum 2 = prod. disc. | Excel Discussion (Misc queries) | |||
Keeping a sum colum correct after inserting a colum of data in fro | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) |