16
Post New Requests Here / I input a CSV file and you tell me if X is within the range of Y.
« on: September 09, 2015, 03:51 AM »
I have huge CSV files with numerical values and I want to see if there are any overlaps within a range.
1) I have ONsetX and I want to see if it's within the range of ONsetY and OFFsetY. If yes, let me see the pair.
2) I have ONsetX and OFFsetY, and I want to see if there's any overlap between ONsetY and OFFsetY. If yes, let me see the pair.
I don't even see how to do this within Excel. Can anyone help?
1) I have ONsetX and I want to see if it's within the range of ONsetY and OFFsetY. If yes, let me see the pair.
2) I have ONsetX and OFFsetY, and I want to see if there's any overlap between ONsetY and OFFsetY. If yes, let me see the pair.
I don't even see how to do this within Excel. Can anyone help?