I understand the 1-3 and possibly the 5-7, but how is 8 10 continuous ?
Also it is not 5-8 as continuous ?

Or are there other rules ?

NickHK

"Tamil" wrote in message
oups.com...
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