Hi gurus,

I have to summarize a excel file with thousands of digits (phone-numbers).
I'll give you an example:

Columns A, B and C
where A is a DIGITS
B is the ROUTE ID

digits route id
40041001 5
40041002 5
40041003 5
40041004 5
40041005 6
40041006 6
40041007 6
40041008 9
40041009 9
40041010 9
40041011 7
40041012 11
50012001 11
50012002 11
50012003 11
50012004 102
50012005 102
50012006 102
50012007 102

I need to summarize this digits/route
The results done manually would be:

summarized digits summarized route id
40041001-40041004 5
40041005-40041007 6
40041008-40041010 9
40041011 7
40041012, 50012001-50012003 11
50012004-50012007 102


So it means:
all the digits from 40041001 until 40041004 will be sent to route 5
all the digits from 40041005 until 40051007 will be sent to route 7
all the digits from 40041008 until 40041010 will be sent to route 9
40041011 will be sent to route 7
all the digits from 50012001 until 50012003 will be sent to route 11 + 40041012
all the diigts rfom 50012004-50012007 will be sent to route 102
and so on.

I have more than 30.000 entries to analyze and I would not like to spend several days doing it

Any ideas?

Regards