Get the latest revision
Table of Contents Get the latest revision Create a list with most recent data available 1. Get the latest revision […]

Find last value in a column
This article demonstrates formulas that return the last value in a given cell range or column. The image above shows […]

Find last matching value in an unsorted list
This article demonstrates a formula that returns the last matching value based on a given condition. The above image shows […]

Lookup with any number of criteria
This article demonstrates a formula that allows you to search a data set using any number of conditions, however, one […]

How to perform a two-dimensional lookup
Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]

Find closest value
This article demonstrates formulas that extract the nearest number in a cell range to a condition. The image above shows […]