Getting row of cell with maximum value.
Getting row of cell with maximum value.
This first picks the maximum value in col. H, so you can't have anything else in col. H besides your list of values you want to check at least nothing that would be a greater number than any of those values.
The MATCH function returns the relative position in col H of the maximum number, and that relative position is simply the row number.
Getting row that meet 2 or more conditions.
Getting row that meet 2 or more conditions.
This MATCH formula, as an ARRAY (CTRL-SHIFT-ENTER), return the row number once meet the following conditions:
It has 'a' in col. E and '11' in col. F
You can use concatenate (&) to add more conditions.
Return text value found most frequently in a column.
The MODE function, one of Excel's statistical functions, tells you the most frequently occurring value in a list of numbers.
The syntax for the MODE function is:
= MODE ( number1, number2, ... number255 ).
