column autofill question

  • Thread starter Thread starter JohnBee
  • Start date Start date
J

JohnBee

I am trying to autofill a column with the same date, but have the autofill
change when a new date is encountered in the column.
 
i don't think you can do it within the same column. there'd be no way
for an excel formula to compare & recognize a new date.
IMHO you'd need a helper column.......

dates are in colum a
formula in cell b1 would be:
=a1
formula in cell b2 would be:
=IF((A1=A2),A1,A2)
formula in cell b3 would be:
=IF((A2=A3),A2,A3)

drag down & autofill
hope it helps!
susan
 
Assuming A1 has a date.

A2:A10 blank

A11 has a date.

A12:A20 blank.

A21 has a date.

Select column A and F5>Specuil>Blanks>OK

Type an = sign in active blank cell(A2) and then point or arrow up to A1.

Hit CTRL + ENTER.

You can copy/paste special>values to get rid of the formulas.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Date Function 3
Vlookup, Column Index Num and Autofill 9
VBA to autofill from relative location 2
autofill down won't work!!!! 3
Autofill cell references with a pattern of every 110 rows 3
Formula doesn't copy correctly 1
autofill results appear as "$ -" with no error, why? 2
Edit Multiple Cells 15

Back
Top