RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 810
- Office Version
- 365
- Platform
- Windows
I found this formula which returns the rightmost non-blank cell in a range:
=LOOKUP(2,1/(P7:S7<>""),P7:S7)
Can I instead specify, like... M7, O7, Q7, S7?
Cheers.
=LOOKUP(2,1/(P7:S7<>""),P7:S7)
Can I instead specify, like... M7, O7, Q7, S7?
Cheers.