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
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