the next value

A

alvin Kuiper

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
 
M

Mike H

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
 
J

Jacob Skaria

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,MATCH(B1,$A$1:$A$3,0)+1))


If this post helps click Yes
 
A

alvin Kuiper

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:
 
A

alvin Kuiper

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,MATCH(B1,$A$1:$A$3,0)+1))


If this post helps click Yes
Click to expand...
 
Top