S Shabbo Member Feb 12, 2017 #1 Dear sir, I have data like attached sheet, and I wanted to know which Invoice numbers are missing in between. How to find that ? Attachments MY INVOICES.xlsx 8.8 KB · Views: 5
Dear sir, I have data like attached sheet, and I wanted to know which Invoice numbers are missing in between. How to find that ?
Hui Excel Ninja Staff member Feb 12, 2017 #2 B3: =IF(RIGHT(A4,3)-1<>RIGHT(A3,3)-0,LEFT(A3,5)&TEXT(RIGHT(A3,3)+1,"000"),"") Copy down
N NARAYANK991 Excel Ninja Feb 13, 2017 #3 Hi , See the uploaded file. Narayan Attachments MY INVOICES.xlsx 10.1 KB · Views: 9
