Fill colum to the next non blank row
You are very welcome
--
Gary''s Student - gsnu200731
"coastal" wrote:
Thanks that worked like a charm!
--
--coastal
"Gary''s Student" wrote:
Let's use a helper column say col D.
In D1 enter:
=A1
In D2 enter:
=IF(A2="",D1,A2) and copy down the column
This will look like column A with the blanks filled in.
Finally copy col D and paste/special as value back onto column A.
At this point col D can be cleared
--
Gary''s Student - gsnu200731
"coastal" wrote:
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
|