I need some help find a formula to extra the max value from a row across 5 columns.
Column A, B, C, D, E have values of 10, 8, 7, 6, 5 in row 1 respectively. What formula can return me the max value (and ideally name of column)? How would I get send-highest value?
Max seems to only work within one column.