What is a good formula to use to identify a gap in sequence?
I've created a sheet that tracks the check sequence used for each of the clients that we manage. I have the following columns: client, check date, beginning check number, ending check number, and upload date.
What is a good formula to identify a gap in the check sequence by the client? Each client has their own check sequence.
Help Article Resources
Check out the Formula Handbook template!