Build The Logic with Eight Nested Functions to Extract Missing Invoices
Although you know many Excel Functions, you might have an excel work problem that we are unable to solve.
In this series, I show you how to break down the problem, to build the LOGIC for a solution, using the knowledge you already have.
So Let’s dive in
In this tutorial we create 8 nested functions to extract a list of Missing Invoice numbers.
Note: The solution I used requires a Dynamic Array Function available in Microsoft 365.
If you do not have Dynamic Array Functions, try this instead: by the way, I wrote this function away from Excel so I did not have a chance to test it.
=SMALL(IF(ISNA(
MATCH(
ROW(INDIRECT(MIN($A$3:$A$70)&":"&MAX($A$3:$A$70))),$A$3:$A$70,0)),
ROW(INDIRECT(MIN($A$3:$A$70)&":"&MAX($A$3:$A$70)))),
ROW(A1))