Filling the gaps in a column of Dates.

[SLEEK]

Good afternoon all,

I'm loving the forums btw. learning oodles.


Here's the thing, I have a s/s with about 6000 rows. It records occurences in date order. Column A is the date Column B thru to AY contains other stuff !

Every Row should have a date in column A. There could be 10 entries on one day (10 rows) and 3 on the next. But only the first row of that day is filled in.

I am trying to fill in the gaps in column A by way of a formula instead of doing it manually.


Has anyone come accross this sort of problem before ? I could use some inspiration before I have to start the manual procedure !


Many thanks chaps

(I wont ask anywhere else before someone comes back to me)

 

[Luke M]

What are you filling in the gaps with? The data from above? If so, see:

http://chandoo.org/wp/2011/10/17/fill-blank-cells-in-a-table/

 

[SirJB7]

Hi, SLEEK!


You can try this:

a) in a helper column, let's say AZ type this in row 2 (if your data start there):

=SI(ESBLANCO(A2);AZ1;A2) -----> in english: =IF(ISBLANK(A2),AZ1,A2)

b) copy down as needed

c) copy AZ column pasting values over A column

d) delete AZ column values


Regards!

 

[SLEEK]

WOW ! My work is done ! Just like that


Luke M. Thank You, The link to the fill-blank-cells-in-a-table didnt work the first time as I was reading it relatively and didnt update the formula to change MY cell above! what a clutz.


In my strive to learn, I tried out SirJB7's helper column solution too. That worked a treat also.


Many Thanks for your help and time.

 

[Luke M]

Glad we could help, thanks for the feedback. =)

 

[SirJB7]

Hi, SLEEK!

I agree with Luke M's words and welcome back whenever needed or wanted.

Regards.