|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 15th, 2009, 08:22 AM
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
May 15th, 2009, 08:37 AM
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
May 15th, 2009, 08:38 AM
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
May 15th, 2009, 08:42 AM
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
May 15th, 2009, 08:56 AM
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
May 15th, 2009, 04:55 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
