Okay, try this ...down on Q29 enter the "=" and with your mouse click cell Q1
and enter, then on Q29 just copy across from Q to S29. I hope it works. :)
--
D Workalcholic


"A.S." wrote:

Not quite sure this does what I need it to. Let me start over with this data:

Q1=1 & R1=3
Q2=4 & R2=7
Q3=25 & R3=27

Now, let's say Q28=Q1=1. Then R28=2, S28=3.
Q29=4, R29=5, S29=6, T29=7
Q30=25, R30=26, S30=27.

Is this possible?


"driller" wrote:

c1=2
d1=7

c2=c1
c3
=IF(AND(C17++SIGN($D$1-$C$1)*1<=MAX(C$1,D$1),C17++SIGN($D$1-$C$1)*1=MIN(C$1,D$1)),C17+SIGN($D$1-$C$1)*1,"END HERE")

data sequence based on entry at C1 and D1, where C2 = C1 and always the
start of the sequence..

--
*****
birds of the same feather flock together..



"A.S." wrote:

I am trying to do the following:

lets's say in cell C1 I input 2 and in cell D1 I have input 7
Then starting in cell C2, I would like it to list me all number including in
between so that C2=2, C3=3,C4=4,C5=5, C6=6, C7=7.

Let's say I have in C1=26 and D2=32
then C2=26, C3=27, C4=28, C5=29, C6=30, C7=31, C8=32.

Any ideas. Thanks.