07-06-2005, 01:05 PM
|
|
|
|
Re: Two quick questions
If you mean 3 rows of the same date, then use
=IF(MOD(ROW(),3)<>1,A1,A1+1)
and copy down as before
--
HTH
Bob Phillips
"timdee" <timdee.1rr73j_1120662618.3565@excelforum-nospam.com> wrote in
message news:timdee.1rr73j_1120662618.3565@excelforum-nospam.com...
>
> Thanks Guys. Bob, is there a simple way of inserting an occasional 3rd
> row with the same date?
>
>
> --
> timdee
> ------------------------------------------------------------------------
> timdee's Profile:
http://www.excelforum.com/member.php...o&userid=24943
> View this thread: http://www.excelforum.com/showthread...hreadid=384795
>
|