Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
column autofill question
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
column autofill question
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 On Dec 20, 12:20 pm, JohnBee wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
column autofill question
Assuming A1 has a date.
A2:A10 blank A11 has a date. A12:A20 blank. A21 has a date. Select column A and F5SpecuilBlanksOK Type an = sign in active blank cell(A2) and then point or arrow up to A1. Hit CTRL + ENTER. You can copy/paste specialvalues to get rid of the formulas. Gord Dibben MS Excel MVP On Thu, 20 Dec 2007 09:20:00 -0800, JohnBee wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofill script question | Excel Discussion (Misc queries) | |||
Question about Autofill with a formula | Excel Discussion (Misc queries) | |||
question about tricky autofill for series | Excel Discussion (Misc queries) | |||
autofill question | Excel Discussion (Misc queries) | |||
Autofill question | Excel Worksheet Functions |