Macro for Missing Numbers

Closed
bhas_kri123 Posts 1 Registration date Saturday September 18, 2010 Status Member Last seen September 18, 2010 - Sep 18, 2010 at 08:09 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 20, 2010 at 09:09 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 19, 2010 at 06:12 AM
When you say missing number, one thing is not clear what is the starting number and what is the ending number ?
Ambucias Posts 47310 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,165
Sep 19, 2010 at 06:38 AM
Sound the trumpets, make the bells ring and let the banners fly! Rizvisa is back!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 20, 2010 at 09:09 AM
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