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
|