Forum Discussion
RubenBo
Nov 04, 2022Copper Contributor
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. ...
OliverScheurich
Nov 04, 2022Gold Contributor
An alternative could be conditional formatting. You can compare a list of all invoices with the list of available invoices. To do this you can apply:
Conditional formatting -> Highlight cell rules -> Duplicate Values -> Unique