formula to arrive min amount or total which is higher in excel code example Example: minimum value between two columns gives column name in excel =MATCH(MIN(A1:D1),A1:D1,0)