intersection

  1. kelly mort

    VBA code to locate intersection of a row and a column

    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...
  2. B

    Intersection in Excel VBA

    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 =...
  3. M

    Altering code from Worksheet_Change so that Undo works

    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...
  4. P

    Time intersect

    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)...
  5. L

    Lookup and Calculate Overlap of a Date Range to a Second Date Range

    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...
  6. I

    Green Triangle Intersection of Row and Column Headings Under Name Box

    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-
  7. I

    Index, Match (Intersection cell data)

    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)...
  8. J

    Help with background fill and intersecting rows and columns

    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...
  9. M

    find two curve intersection realtime!

    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...
  10. J

    Using value criteria in two columns to find row in which two columns most closely match the criteria

    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...
  11. B

    Lookup Intersection using Multiple Criteria and Return Value

    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...
  12. philfriday

    Complex data transfer from one workbook to another

    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...
  13. B

    Determining the date when two trendlines intersect

    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...
  14. W

    PLEASE HELP!! finding intersection between two variable and inserting a value

    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...
  15. 9tanstaafl9

    Need to find value at intersection of row and column

    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...
  16. K

    Existing customer base- changing the base in powerpivot

    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...
  17. B

    Multiple Intersections, Conditional Formating

    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...
  18. T

    Line intersection - with a difference

    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...
  19. U

    Filtering a Matrix w/ a Vector and Summing/Counting Values in a Column

    Seeking your help to determine an array formula that will filter the values in the first column of a table (multiple rows and columns) with the values in an array and summing or counting specific values in a column of the remaining unfiltered rows. The data table consists of the following on...
  20. Z

    Tracker Question - Looking for a Macro that auto changes cells based cell intersection

    Good Morning, this is my first forum, so please bare with me. I am producing a tracker for some people so that we can track and update any training that we need to complete and know when we need to complete it. What i am looking for is as follows. I a to have a database (I have made already)...

Some videos you may like

This Week's Hot Topics

Top