Hello. I am trying to work with excel data where there are several columns. The column value can be numeric and alpha numeric. I am looking for a minimum value of all columns if there are any numeric value and the result is subtracted by 36. If all columns have value of “never done” than the result should be “never done” Please see example below where its taking the minimum value of all the columns and subtracting the result by 36 to give the final result.
Please let me know if you have any further questions. Thanks