Hey guys,

I couldn't find an answer to this via searching (maybe just not using keywords) but I wondered if you could help me out.

I have a range of numbers in rows such as:

A 55-65
B 64.8 - 70
C 58-59.3

What I want to do is find out if there is a way to find common values that match between these different rows i.e. between A and C any value beween 58 and 59.3 is matching but nothing matches between B and C. Matching between A and B are the values 64.8 to 65.

Ideally I'd like the output in a way that displays which rows are matching (A and B) together with the values (64.8 to 65).

Thanks in advance!