Posted to microsoft.public.excel.worksheet.functions

Lyndi

external usenet poster

Posts: 1

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

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting a group of contiguous rows	jfg	Excel Discussion (Misc queries)	1	August 7th 07 06:34 AM
Find missing numbers in a list	contar	Excel Discussion (Misc queries)	9	July 5th 07 06:39 AM
Find Missing Numbers in a List	millie6169	Excel Discussion (Misc queries)	6	November 12th 06 02:59 AM
MISSING NUMBERS IN LIST	jpfrmnm	Excel Discussion (Misc queries)	2	November 10th 06 09:30 PM
How do i identify missing numbers in a sequential list	Chet-a-roo	Excel Discussion (Misc queries)	4	August 5th 05 07:25 PM

All times are GMT +1. The time now is 12:14 AM.

About Us

"It's about Microsoft Excel"