How do I group numbers in a list based on contiguous/missing?

L

Lyndi

I have a list of phone numbers that I need to break into contiguous ranges,
i.e.; 2372-2385, 2389-2402. Is there a way to do this with a function?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF Non Contiguous Cells Q 3
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Resource Pool Project 2016 Standalone - how to remove reference to previously Shared, now deleted, files 0
Link a text box based on drop down box with four options MS Word 365 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
COUNTIF for multiples of 3 3
How can the font and size of (all) citation numbers be altered? 1

Top