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,