intersection

Hi All, I have the definition of several ranges of straight lines: 1, 2, 3, 4 and 5, where I define the x- and the y- coordinates only for the start and end points of the lines. I would like to have a "Desired" range that sums the values in every coordinate of the range. I would like to do this...

Happy day Below is the data of my work and codes which I wrote with the help of google search. Data size will be variable. I used numeric number "1" at the end of the workable range at the column c to identify the last row. I will enter values at the 8th row. I used the match function and...

I have these two variables: 1. MyRow 2. MyColumn I am identifying them with an input box entry So if myrow becomes A2 and mycolumn becomes F1 , then I am looking for a code to get that intersection (F2) for me. I will be placing some data at the intersection. But I don't know how to get the...

I have two non-contiguous ranges which contain one common value. I want to use the intersection method to trigger a macro but this code does not do it. Any help please Sheet7.Activate With Sheets("Sheet7") Set xrange = Sheets("sheet7").Range("A7:A9") Set xcells =...

Hi, I posted a question about this earlier, but have discovered a little bit more on my own and have run into a different problem. With the following code, the Undo function is effectively removed. Do I have any options for replicating this code but not making it a worksheet change dependent...

Hi all, Is there a way to get the number of hours intersected by 2 time periods? For example: 09:00 to 18:00 vs 21:00 to 06:00 = 0 hr (no intersection) 18:00 to 03:00 vs 21:00 to 06:00 = 5 hrs (this is from 22:00-03:00) 00:00 to 09:00 vs 21:00 to 06:00 = 6 hrs (this is from 00:00-06:00)...

I have seen the posts on using Lookup to check if a date falls between a range of dates, but I need to compound that now and check the range of dates against a range of dates. I have start & stop dates for steps in a process, but if the days include holidays, I need to adjust the total time...

First time see a green triangle at the intersection of the row and column headings under the name box (top left of spreadsheet) suddenly appeared and hid 30 rows. What is it and how to undo it? By the way the triangle am describing is not the cell indicator error. Thanks-

Hello Everyone, I'm trying to extract some data from cell intersection by using index and match functions, I have checked a lot of video and checked alot of forum posts but i can't do it. I'll really appreciate your support. Target cell is shown below (Green Highlighted)...

Hello everyone, First of all, thank you for reading this to see if you can help me. My question is I would like to know how to create a spread sheet that has alternating rows and columns filled but the background fill stops at the intersection. I have included an image of...

Hello all, hope the best. I have two set arrays that I want to find intersection point of them. One way is to fit a trendline and find the equation for each. then solve the equations and find the intersection. Problem is that everytime that any of those arrays changed a new trendline need to be...

Hello, So I have 80 or so large data sets that I have smoothed and then found the slope between each point. I then calculate the average change of the slope along the curve. I would like to search for a row in the two columns where the average slope percent change is less than 1% in one column...

Hello, Thanks for taking the time to look into this for me. Here is the issue that I've been trying to fix for about a week. I would like to email you the attachment if you're going to help me out because for some reason, I am not allowed to add attachments to my post and it would be really...

Hi guys, I have two workbooks (different files) that I need to feed information from one to another. The source has different funds (European Growth Portfolio, etc.) listed horizontally and products (Ultra 75/75 Series, etc.) listed vertically. The intersections contain add if they need to be...

Hello, I have two data series that are plotting on a date range (the x axis). I've added trendlines to each data set, and at some point in the future these two trendlines cross. I'm interested in being able to determine the date when these two trendlines cross. In the attached file you can...

I've been trying for a couple weeks to create a vba that will fill out my project calendar for me. First thing i am trying to do is have the vba find the intersection between two variable and insert a string into the intersecting cell. I have tried various things such as match, vlookup and find...

Sorry if this is obvious, but I have no idea how to even look it up. I've never done anything similar. I have timecard values on one sheet that look something like this: employee # 1 1 2 2 type ST OT...

Hi- thanks for helping. I haven't been able to find a solution for this and have been pulling my hair out for days. I have a great big powerpivot table with all our customer sales by customer by quarter for the past couple of years. I want to be able to see how our customer base has evolved...

I'm looking to apply a cell highlight to all intersections where the row and column heading match. The data set will be a pivot table, but if this prohibits the application of formatting I can work with a table. Solution needs to be Excel 2007 compatible. An example of what I'm looking for...

I have been working on a problem and through all of my research I have been unable to find an existing resolution. I do not have the required math knowledge to produce an elegant solution. There are several examples of working (and very elegant) line - line intersections with either complete...