Here's an example of what I need:
ColumnA
1
2
3
4
6
7
8
10
15
16
Instead of manually hunting down the gaps, is there any way for me to get the above shown in a range, like this?
1 - 4
6 - 8
10
15 - 16
OR
1 - 4, 6 - 8, 10, 15 - 16
OR
1 - 4; 6 - 8; 10; 15 - 16
Thanks in advance!