| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup for last value in a row
Hello again,
I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
Maybe
=INDEX(A1:E1,MATCH(REPT("z",20),A1:E1,1)*1) Mike "driller" wrote: Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
=LOOKUP(2,1/(A1:E1<""),A1:E1)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
thanks a lot.
-- best regards, "driller" wrote: Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
No need for the *1
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Maybe =INDEX(A1:E1,MATCH(REPT("z",20),A1:E1,1)*1) Mike "driller" wrote: Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
my wrong,
i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
If it is all text
=INDEX($A$1:$E$1,MATCH(REPT("z",20),A2:E2,1)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
Your right, thank you
"Bob Phillips" wrote: No need for the *1 -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Maybe =INDEX(A1:E1,MATCH(REPT("z",20),A1:E1,1)*1) Mike "driller" wrote: Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
Hi,
It's a bit long winded now you want the date as well =INDEX(A2:E2,MATCH(REPT("z",20),A2:E2,1)) &" ["&TEXT(INDEX($A$1:$E$1,MATCH(INDEX(A2:E2,MATCH(REP T("z",20),A2:E2,1)),A2:E2,FALSE)),"DD/MM/YYYY")&"]" Mike "driller" wrote: my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
your formula works again. many thanks today().
-- regards, "Mike H" wrote: Hi, It's a bit long winded now you want the date as well =INDEX(A2:E2,MATCH(REPT("z",20),A2:E2,1)) &" ["&TEXT(INDEX($A$1:$E$1,MATCH(INDEX(A2:E2,MATCH(REP T("z",20),A2:E2,1)),A2:E2,FALSE)),"DD/MM/YYYY")&"]" Mike "driller" wrote: my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
Your welcome and thanks for the feedback
"driller" wrote: your formula works again. many thanks today(). -- regards, "Mike H" wrote: Hi, It's a bit long winded now you want the date as well =INDEX(A2:E2,MATCH(REPT("z",20),A2:E2,1)) &" ["&TEXT(INDEX($A$1:$E$1,MATCH(INDEX(A2:E2,MATCH(REP T("z",20),A2:E2,1)),A2:E2,FALSE)),"DD/MM/YYYY")&"]" Mike "driller" wrote: my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
thanks Sir Bob, i have real dates to be lookup. I use Mike's formula.
-- regards, "Mike H" wrote: Hi, It's a bit long winded now you want the date as well =INDEX(A2:E2,MATCH(REPT("z",20),A2:E2,1)) &" ["&TEXT(INDEX($A$1:$E$1,MATCH(INDEX(A2:E2,MATCH(REP T("z",20),A2:E2,1)),A2:E2,FALSE)),"DD/MM/YYYY")&"]" Mike "driller" wrote: my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup for last value in a row
Active Worksheet:
=LOOKUP(10000000000,F:F) Another Worksheet: =LOOKUP(10000000000,'Sheet1'!F:F) Regards, Ryan--- -- RyGuy "driller" wrote: thanks Sir Bob, i have real dates to be lookup. I use Mike's formula. -- regards, "Mike H" wrote: Hi, It's a bit long winded now you want the date as well =INDEX(A2:E2,MATCH(REPT("z",20),A2:E2,1)) &" ["&TEXT(INDEX($A$1:$E$1,MATCH(INDEX(A2:E2,MATCH(REP T("z",20),A2:E2,1)),A2:E2,FALSE)),"DD/MM/YYYY")&"]" Mike "driller" wrote: my wrong, i forgot to place that the date shall be in the result as well. I have a long list to paved by the formula. A B C D E F=RESULT DATE 2-Jan-08 14-Jan-08 22-Jan-08 1-Feb-08 AA N1 N2 N2 (22-Jan-08) BB N3 N13 N13 (22-Jan-08) CC N01 N02 N06 N06 (1-Feb-08) DD N8 N11 N11 (22-Jan-08 EE N6 N9 N9 (14-Jan-08) thanks again -- regards, "Bob Phillips" wrote: =LOOKUP(2,1/(A1:E1<""),A1:E1) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "driller" wrote in message ... Hello again, I forget the formula to find tha last value in a row A B C D E F=RESULT AA N1 N2 N2 BB N3 N13 N13 CC N01 N02 N06 N06 DD N8 N11 N11 EE N6 N9 N9 looking for a formula on column F. thanks in advance. -- regards, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Linear Mode
