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!
Bookmarks