How to get last match

How to get last match

This article shows how to get last match by using MAX, MIN, IF and ROW functions. Excel’s array formula ability to evaluate formula for each cells in an array is key factor in this case. Syntax { =MAX( IF( data = search value, ROW( data ) – MIN( ROW( data...
How to use multiple IF functions

How to use multiple IF functions

The IF function is great for creating a logic statement. But IF is an either/or argument, what if you need more alternatives? Combining several IF statements in a nested structure can help overcome this. Syntax =IF(first logical test, do something if first test is...