+ Reply to Thread
Results 1 to 5 of 5

Find Intersect of Range of number

Hybrid View

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Lightbulb Find Intersect of Range of number

    I have two column sub range of natural number ( N ) :
    col1 col2
    0-2 12-13
    7-11 18-21
    20-25 28-30
    tips: a-b is equal [a,b] in N
    OK, I wanna compare each cell of col1 with all of cell in col2 and find intersect sub range,
    for example ( 20-25 on col1 )
    20-25 compare with 18-21 and get this result ( intersect ) : 20-21


    or, you can suppose sheet to this form, too:
    col1 col2 col3 col4
    0 2 12 13
    7 11 18 21
    20 25 28 30

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Find Intersect of Range of number

    Check the attached
    Attached Files Attached Files
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Registered User
    Join Date
    03-06-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Re: Find Intersect of Range of number

    Quote Originally Posted by sourabhg98 View Post
    Check the attached
    Thank you so much dear sourabhg98

    please check this file for some small problem

    RE1_SUBRANGEINTERSECT.xlsx

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Find Intersect of Range of number

    Can there be more then one intersections too??

  5. #5
    Registered User
    Join Date
    03-06-2015
    Location
    india
    MS-Off Ver
    2007
    Posts
    3

    Re: Find Intersect of Range of number

    Quote Originally Posted by sourabhg98 View Post
    Can there be more then one intersections too??
    yes, more than one intersections between column one item AND column two items

    sudo code
    for i=1 to count(col1)
    for j=1 to count(col2)
    check(col1[i],col2[j])

    for example 1 :
    col1 col2
    1-2 1-15
    4-6 -
    3-5 -
    Answer :
    1-2
    4-6
    3-5

    for example 2 :
    col1 col2
    1-4 0-6
    - 1-9
    - 2-15
    Answer is :
    1-4
    1-4
    2-4

    thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find intersect and replace cell value
    By amar05 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-19-2013, 06:15 PM
  2. Find function and Intersect
    By mpalm in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-27-2011, 01:04 PM
  3. Find all cells with given text and how to do the opposite of Intersect
    By Leshak in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2010, 05:34 AM
  4. how to find an intersect of two columns
    By sarora in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-30-2006, 10:40 PM
  5. How do I find where a column value and row value intersect?
    By Amy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 08:06 PM

Tags for this Thread

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