Hello.
I am trying to create a formula, that would look up the name of the column with the last value OK as per example below. Could you please help with the syntax?
Max#1 Max#2 Max#3 Max#4 Expected Result
NOT OK OK OK OK Max#4
NOT OK OK NOT OK NOT OK Max#2
NOT OK OK OK NOT OK Max#3
Thank you in advance.
Alisa
Bookmarks