Excel last value in a row

SR-71

SR-71

Active member
OK i need to extract the last value in a row but I can't find the way to do it

I have a few data in the first few cells, after that I have a list of date, I need to display in a cell the last date, tried the lookup (2,1/blabla) no success, found nothing helpful on internet :(

Later I will also need to find the last date entered but in this case
c1 c2 c3 c4 c5 c6 c7

note1 note 2 note 3 date scheduled date done date scheduled date done

I will need to extract the last date done so I need to avoid all the date scheduled

This is driving me crazy
 
SR-71 said:
OK i need to extract the last value in a row but I can't find the way to do it

I have a few data in the first few cells, after that I have a list of date, I need to display in a cell the last date, tried the lookup (2,1/blabla) no success, found nothing helpful on internet :(

Later I will also need to find the last date entered but in this case
c1 c2 c3 c4 c5 c6 c7

note1 note 2 note 3 date scheduled date done date scheduled date done

I will need to extract the last date done so I need to avoid all the date scheduled

This is driving me crazy
Click to expand...

Seems like you dataset is build horizontally instead of vertically.

If it's a row, you need the offset formula
=OFFSET(B2,0,MATCH(MAX(B2:XFD2)+1,B2:XFD2,1)-1),

if its a column, you need the lookup formula
=LOOKUP(2,1/B:B<>""),B:B)
 
=LOOKUP(2,1/B:B<>""),B:B) finally works, but for me it is LOOKUP(2;1/B:B<>"");B:B).... formula with , was not working... One problem solved
Still have to do the same thing for the second sheet
 
You must log in or register to reply here.
Back
Top