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
|