Forum Discussion
Formula Finding missing sequence
Hi all, I have been searching the internet for days but it looks like many formulas dont work on our excel... But maybe someone can help me out. We need a formula to find missing invoices. ...
If you have FILTER, you might try:
=LET(seq,SEQUENCE(1+MAX(invoice)-MIN(invoice),,MIN(invoice)),FILTER(seq,ISERROR(XMATCH(seq,invoice))))