Re: Two quick questions

I would use another cell to toggle it, like this

=IF(MOD(ROW(),IF(H1<>"",3,2))<>1,A1,A1+1)

and when you want it for a third row, put any value in H1, when you want
every second, clear H1


--
HTH

Bob Phillips

"timdee" <timdee.1rskyd_1120727110.4079@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:timdee.1rskyd_1120727110.4079@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Bob, I am most grateful for your help. Just to clarify what I am trying
> to achieve. Each day I usually have 2 rows of data to enter, but just
> occasionally there will be a third row required for a day, then I will
> revert back to two rows again. I am not sure if this is possible and I
> don't want to take up any of your valuable time. but would appreciate
> your advice.
>
>
> --
> 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
>


.