the next value
 

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin

the next value
 

Hi,

I don't understand. Please explain the logic for deriving the second value
from the first with particular emphasis on 'and so on'

02.01-28.02
01.03-31.10


Mike

"alvin Kuiper" wrote:

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin

the next value
 

Dear Alvin

Try the below. You have the below series in A1:A3

02.01-28.02
01.03-31.10
01.11-01.01

In B1 enter "02.01-28.02"
In B2 enter the below formula and drag that down...

=INDEX($A$1:$A$3,IF(MATCH(B1,$A$1:$A$3,0)=3,1,MATC H(B1,$A$1:$A$3,0)+1))


If this post helps click Yes
---------------
Jacob Skaria


"alvin Kuiper" wrote:

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin

the next value
 

Yes
In a cell i have a value like: 02.01-28.02
in the next cell i have i want the value from the next row
in the matrix
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*
In this case 01.03-31.10
But if my value in my first cell is 01.11-01.01
then the value in my second cell shal be Påske mv*
because this is the next row
Alvin


"Mike H" skrev:

Hi,

I don't understand. Please explain the logic for deriving the second value
from the first with particular emphasis on 'and so on'

02.01-28.02
01.03-31.10


Mike

"alvin Kuiper" wrote:

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin

the next value
 

thanks

Alvin


"Jacob Skaria" skrev:

Dear Alvin

Try the below. You have the below series in A1:A3

02.01-28.02
01.03-31.10
01.11-01.01

In B1 enter "02.01-28.02"
In B2 enter the below formula and drag that down...

=INDEX($A$1:$A$3,IF(MATCH(B1,$A$1:$A$3,0)=3,1,MATC H(B1,$A$1:$A$3,0)+1))


If this post helps click Yes
---------------
Jacob Skaria


"alvin Kuiper" wrote:

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin

the next value
 

=INDEX($A$1:$A$3,MOD(ROW()-1,3)+1)


"alvin Kuiper" wrote:

Hi!
I have this in some cells.
02.01-28.02
01.03-31.10
01.11-01.01
Påske mv*

In another cell I have
01.03-31.10
What i want now in another cell
is the next vaule (row) after
01.03-31.10
But if my value in my first cell is 02.01-28.02 then
the next value (row) is 01.03-31.10 ans so on

Can i do this ?

Alvin