Return offset value of overlapping values to a single cell

[Akorax]

Hello!

Excel version: 2010

I'm trying to compare a value range from a unit in a table with every other unit in that table to find out if there are any overlapping value ranges. The range to compare consist of a minimum value and a maximum value. If one or more range overlaps are found, the overlapping unit(s) will be named in a new colum.
The reason for this is to find out if the units need further analysis on other values/parameters (not named here) to distinguish them from eachother.

Below you can see a more concrete example of what I'm trying to accomplish with this marvelous program. The example is a small one but the list I want to create may grow up to 30 rows in size.

The formulas I've used this far are:
Cell D19 =NOT((C19<B20)+(C20<B19))
<b20)+(c20<b19))
Cell E19 =IF(D19,"Overlap","No overlap")

I figure this might be impossible to do without the assistance of VBA enabled content but I have a restriction not to use macros/VBA in this case.

[TABLE="class: grid, width: 650"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]List I want to compare[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Names[/TD]
[TD]Min Value[/TD]
[TD]Max Value[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Unit A[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Unit B[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Unit C[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Unit D[/TD]
[TD]35[/TD]
[TD]45[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Unit E[/TD]
[TD]40[/TD]
[TD]60[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Result I want[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Names[/TD]
[TD]Min Value[/TD]
[TD]Max Value[/TD]
[TD]Overlapping with[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Unit A[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]Unit B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Unit B[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD]Unit A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Unit C[/TD]
[TD]30[/TD]
[TD]50[/TD]
[TD]Unit D, Unit E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Unit D[/TD]
[TD]35[/TD]
[TD]45[/TD]
[TD]Unit C, Unit E[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]Unit E[/TD]
[TD]40[/TD]
[TD]60[/TD]
[TD]Unit C, Unit D[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]What I have tried[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]Names[/TD]
[TD]Min Value[/TD]
[TD]Max Value[/TD]
[TD]Overlap[/TD]
[TD]Overlap in plain text[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]Unit A[/TD]
[TD]10[/TD]
[TD]20[/TD]
[TD]TRUE[/TD]
[TD]Overlap[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]Unit B[/TD]
[TD]15[/TD]
[TD]25[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
</b20)+(c20<b19))

 

[Akorax]

HTML screwed my formulas big time.
Here they are uncut (hopefully) this time:

Cell D19 =NOT((C19<b20)+(c20<b19))
Cell E19 =IF(D19,"Overlap","No overlap")</b20)+(c20<b19))