Re: Two quick questions
- From: "Bob Phillips" <phillips@xxxxxxxxxxxxx>
- Date: Wed, 6 Jul 2005 17:09:06 +0100
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@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:timdee.1rr73j_1120662618.3565@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=24943
> View this thread: http://www.excelforum.com/showthread.php?threadid=384795
>
.
- Follow-Ups:
- Re: Two quick questions
- From: timdee
- Re: Two quick questions
- From: timdee
- Re: Two quick questions
- References:
- Two quick questions
- From: timdee
- Re: Two quick questions
- From: timdee
- Two quick questions
- Prev by Date: Re: change date-format
- Next by Date: Re: The best elegant solution to override 65k rows limit in a ***
- Previous by thread: Re: Two quick questions
- Next by thread: Re: Two quick questions
- Index(es):
Loading
