I would like to calculate what percent of one range falls onto another range. I have a high value and a low value for each range.
For example, if Bobby's interval is 5-10, and Katie's interval is 4-8, then Bobby's overlaps onto Katie's 75% (5-8 in the range of 4-8, or 3/4 numbers are the same, 75%). I can do this by hand, but I have thousands of these to do. Anyone know how to do this in Excel using conditional formatting or the like? Thank you!
I have scoured the internet and asked professors, and no one has either had something that will work to calculate percentage specifically, or do not know how to do it not by hand.
Bookmarks