jbesclapez
Active Member
- Joined
- Feb 6, 2010
- Messages
- 275
Hello Mr Excel!
I have a formula that looks like the one I need, but it only does the job for one Column at a time and not a multi column Range.
=+LOOKUP(2,1/(B4:B10<>""),ROW(B4:B10))
From that i get the position of the last non empty member
I would like to get the same but instead of B4:B10 it should be B4:Z10 ...
Can you please do your magic MrExcel?
Thanks.
I have a formula that looks like the one I need, but it only does the job for one Column at a time and not a multi column Range.
=+LOOKUP(2,1/(B4:B10<>""),ROW(B4:B10))
From that i get the position of the last non empty member
I would like to get the same but instead of B4:B10 it should be B4:Z10 ...
Can you please do your magic MrExcel?
Thanks.