Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 3,142
- Office Version
- 365
- Platform
- Windows
I currently use this as part of my OFFSET function to find the last used row because it works with for both numbers and text.
MAX((AB:AB<>"")*ROW(AB:AB))
I've tried using Match(1e+300,AC:AC,1) which will find the last row if all the cells contain numbers. Also Match("zzzzzzzzzzz",AC:AC,1) which works for text.
Does anybody else use something more simple?
MAX((AB:AB<>"")*ROW(AB:AB))
I've tried using Match(1e+300,AC:AC,1) which will find the last row if all the cells contain numbers. Also Match("zzzzzzzzzzz",AC:AC,1) which works for text.
Does anybody else use something more simple?