ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 161
- Office Version
- 2021
- Platform
- Windows
=INDEX(39:39,MAX(IF(MQ39:NM39<>0,COLUMN(MQ39:NM39)))) [Looksup Last Entry]
I need to -MM5 and /MM5 to get a percentage.
I got this far =INDEX(39:39,MAX(IF(MQ39:NM39<>0,COLUMN(MQ39:NM39))))-MM5
but have been unable workout how to do the division.
Cheers.
I need to -MM5 and /MM5 to get a percentage.
I got this far =INDEX(39:39,MAX(IF(MQ39:NM39<>0,COLUMN(MQ39:NM39))))-MM5
but have been unable workout how to do the division.
Cheers.