I'm new to Excel and I need to use it for a scientific paper. I'm trying to optimize my database data gathering workflow.
I need to compare the range created by the columns "Start" and "End" to the different ranges inside the yellow square and output, in the "co-localization" column, if the Start-End range overlaps just the first value (Yes - Start), just the second value (Yes - End), overlaps both (Yes - both) or is just contained (Yes - Contained). If none of the conditions is met, just output "No".
Is this too complex for Excel?
btw: I tagged this question Excel 2010, because that's what I use at home, but if you know how to do this in earlier version I would gladly accept that answer too.