07-06-2005, 06:05 AM
|
|
|
|
Re: Two quick questions
Tim,
Put this formula in A2, and copy down
=IF(MOD(ROW(),2)=0,A1,A1+1)
--
HTH
Bob Phillips
"timdee" <timdee.1rqqai_1120640719.7833@excelforum-nospam.com> wrote in
message news:timdee.1rqqai_1120640719.7833@excelforum-nospam.com...
>
> Firstly, I am using Excel 97 SR-2. My questions are:
>
> If I enter a date in a cell then drag the fill handle down the column
> it increased by one day each time. Is it possible to create 2 rows
> with the same date, then the next two increase by one etc. If so, how
> do I do it?
>
> Secondly, if there is a formula in a cell but no data for it to use it
> displays ####. Is it possible to stop this until data is entered?
> Regards,
> Tim.
>
>
> --
> timdee
> ------------------------------------------------------------------------
> timdee's Profile:
http://www.excelforum.com/member.php...o&userid=24943
> View this thread: http://www.excelforum.com/showthread...hreadid=384795
>
|