Posted to microsoft.public.excel.worksheet.functions

Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline

external usenet poster

Posts: 896

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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 09:26 PM.

About Us

"It's about Microsoft Excel"