Closed Thread
Results 1 to 3 of 3

find intersection and delimit the values

  1. #1
    Forum Contributor
    Join Date
    06-15-2012
    Location
    beirut
    MS-Off Ver
    Excel 2007
    Posts
    212

    find intersection and delimit the values

    dear, i have command button delimits the value of cells i choose and put the result in sheet "pure" from column "C3:E" ( see attached file ) .
    what i need is edit the code to be , example if i select range of cells as "C4:C5" i want to search to the word "Heading5" in row2 and get the intersections between cells i selected and column of "Heading5" "F4:F5" , then delimit them in sheet "pure" in column "C3" and "D3" and "G3" and in column "B3" paste the cells i select it i.e " B , C ".
    note : the word "Heading5" not always exist in same column , so i need to search it in all row2 .

    see attache file

    Best Regards

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: find intersection and delimit the values

    This is an exact duplicate of another thread on this forum. This one should be closed and the other kept open for replies.

    http://www.excelforum.com/showthread...48#post4497748
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: find intersection and delimit the values

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 04-13-2016, 09:53 AM
  2. Replies: 7
    Last Post: 04-10-2016, 11:24 AM
  3. Replies: 3
    Last Post: 11-19-2014, 02:45 PM
  4. VBA to find the range at the intersection of two values.
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-31-2013, 06:10 PM
  5. How to find point of intersection of 2 graphs
    By hellmett in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-11-2012, 11:00 AM
  6. How do I find a value at the intersection of a column and a row?
    By brianalucas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-01-2010, 08:02 PM
  7. find a value at an intersection?
    By Ellen G. in forum Excel General
    Replies: 4
    Last Post: 06-29-2006, 03:40 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1