| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
