View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tamil Tamil is offline
external usenet poster
 
Posts: 6
Default Compare 2 list and extract continous range

Hello,

This is my first post. I have two list of data and want to extract
continous range.
eg. 1 2
2 3
5 6
6 7
8 10

I want continous range like
1 3
5 7
8 10

I have to handle large data. Either formula or query is required.

Thanks,
Panneer selvam