Thread: How do I group numbers in a list based on contiguous/missing?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lyndi Lyndi is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote