Lookup last entry, divided to get percentage.

[ozbeachbum]

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

 

[Alex Blakenburg]

I have to missing something here, why isn't it just:

=(INDEX(39:39,MAX(IF(MQ39:NM39<>0,COLUMN(MQ39:NM39))))-MM5)/MM5

 

[ozbeachbum]

Hi Alex,
Thank you so much works perfectly.
I thought it was a bracketing issue and I tried different combinations before posting.

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.