Forum Discussion
Solved
Excel Max function how to print the row of data that the max value is on
I have 3 columns of data and I am trying to figure out how to print the row that has the maximum value in column 3. Column 1 has cause, column 2 has year it happened and column 3 has the frequenc...
Ben_Millar Attached a file with two possible solutions. See which one works for you. One uses the dynamic array function FILTER. The other INDEX/MATCH entered with Ctrl-Shift-Enter (array formula).
- Thank you. 😊
