Macro for Missing Numbers

Closed
Report
Posts
1
Registration date
Saturday September 18, 2010
Status
Member
Last seen
September 18, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Please help me in finding out missing numbers location wise. Below numbers having different location numbers, request to help me with macro for finding out missing numbers location wise seperately from below data.



AUS-2011-676
AUS-2011-678
AUS-2011-679
CAN-2011-957
CAN-2011-958
CAN-2011-960
GER-2011-309
GER-2011-311
GER-2011-312
OFF-2011-10605
OFF-2011-10606
OFF-2011-10608
OFF-2011-10609
OFF-2011-10610

Thanks in Advance.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
When you say missing number, one thing is not clear what is the starting number and what is the ending number ?
0
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,368
Sound the trumpets, make the bells ring and let the banners fly! Rizvisa is back!
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Ambucias, hope trumpets and bells are not too loud, as Iately I have found it harder and harder to attempt to make my self useful over here. :P But thanks for noticing that Iately I was absent
0