Hello 
I found the following formula to find the last column with data:
But I also need a formula to find the penultimate column.
Can somebody please enlighten me?
Thank you very much in advance.
RankLogic_v1.2.ods (29.3 KB)
O2:
=IFERROR(LOOKUP(2;1/ISNUMBER($B2:$N2);$B2:$N2);"") already in your file
P2:
=IFERROR(LOOKUP(2;1/ISNUMBER($B2:$N2);$A2:$M2);"")
RankLogic_v1.2_LeroyG.ods (23.7 KB)
1 Like
WOW! Thank you so much, @LeroyG !
I would have never figured this out by myself.
Thanks again 
1 Like