LinkBack URL
About LinkBacks
Hi
One way could be this with your numbers starting in A1.
First sort the numbers from minimum to maximum.
Then in B2, put this formula and copy down.
=IF(A2=A1+1,"OK","Missing Invoice")
Hi
One way could be this with your numbers starting in A1.
First sort the numbers from minimum to maximum.
Then in B2, put this formula and copy down.
=IF(A2=A1+1,"OK","Missing Invoice")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks