Category: Lookup and References

Lookup and references functions, comes with Excel

Walking Columns

ANmar January 14, 2023

Get 3rd Wednesday of month

ANmar November 15, 2022

Repeated Offset

ANmar September 19, 2022

Sorting with functions only

ANmar September 5, 2022

Searching table in 2 dimensions.

ANmar July 26, 2022

Search across sheets in function

ANmar July 22, 2022

Min Max vehicle

ANmar July 20, 2022

GoLast to jump to last cell in a column

ANmar July 20, 2020

CHOOSE – tree of decisions

ANmar February 20, 2020

Looplist – Repeating months using formulas

ANmar December 11, 2018

Skills Grid

ANmar October 26, 2018