| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I group numbers in a list based on contiguous/missing?
did you mean that?
=LEFT(A1,FIND("-",A1)-1) =RIGHT(A1,LEN(A1)-FIND("-",A1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting a group of contiguous rows | Excel Discussion (Misc queries) | |||
| Find missing numbers in a list | Excel Discussion (Misc queries) | |||
| Find Missing Numbers in a List | Excel Discussion (Misc queries) | |||
| MISSING NUMBERS IN LIST | Excel Discussion (Misc queries) | |||
| How do i identify missing numbers in a sequential list | Excel Discussion (Misc queries) | |||
Linear Mode
