Excel formula seq number

[Pohguan]

HI

I have a listing like below, i need to convert this to a summary. If the unit number is in sequence, it will show start of number - end, if not just the number itself. Need to do this because the list is very long.
Is there a formula or technique that i'll be able to do this instead of manually?


Division Unit
A 1
A 2
A 3
A 4
B 5
A 6
B 7
B 8


Desire output
Division Unit
A 1-4, 6
B 5, 7-8

 

[James006]

Hi,
In order to properly condense your strings, how is your Data structured ?
Are your "Division-Unit" located in one single cell for each Division, or each item is located in a dedicated cell ?

 

[Pohguan]

Hi James,

Division and Unit is in different column, so each item has dedicated cell.

Hope this clarifies

 

[James006]

In my opinion, there is quite a number of steps to reach ... the starting line ...
The first two steps could be :
1. Sort in ascending by Division and by Unit
2. Concatenate all Units with same Division in one cell