summarize thousand route digits

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

This works for your example, but I'm not sure how viable it is for 30K entries! Try it and see.

Please Login or Register  to view this content.

Hi, You say there are 3 columns "A, B & C", so I've taken the "Digits" in "A", the "Route" in "B" and the i/d's in "C".
The results are in column "E", if you want them in separate cells call back.

Please Login or Register  to view this content.

Regards Mick

Originally Posted by StephenR

This works for your example, but I'm not sure how viable it is for 30K entries! Try it and see.

Please Login or Register  to view this content.

This might be useful with some changes !!!
Thanks a lot Stephen

Regards

Kmare.