Occurences

Does anyone have a suggestion for the following please?

Column's AB are the red ranges, DE are the blue ranges.
Row 1 is the 1st data range for each type of data set.
I would like to be able to see where the red range set. i.e. from row 1 down to 34 (there will be more or less rows each time)
has data values that overlap and be able to read how many occurrences of overlap please.

Your thread is being closed for non compliance with our rules. Please PM me when you have read the forum rules http://www.excelforum.com/forum-rule...rum-rules.html and made the changes to your post accordingly, i will then unlock your post so you may continue with the thread!

Post Closed