+ Reply to Thread
Results 1 to 2 of 2

Get unique values based on multiple criteria

  1. #1
    Registered User
    Join Date
    11-28-2019
    Location
    Calgary, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    1

    Get unique values based on multiple criteria

    I have data like below:

    IDENTIFIER DATE Job TOP BOTTOM
    X 1983-10-27 Perf 655.2 658.2
    X 1983-10-31 Perf 624.5 625
    X 1983-10-31 Cement 654 662
    X 1983-11-30 Perf 625 626
    X 1984-04-13 Cement 624.5 626
    X 1984-04-19 Perf 625.5 626
    X 1984-04-26 Perf 625 625.5
    X 1984-05-15 Cement 625 626
    X 1984-05-17 Perf 655.2 658.2
    X 1984-05-29 Perf 644 646
    Y 1988-12-28 Perf 621.5 622
    Y 1994-03-25 Perf 621 625
    Y 2001-02-10 Cement 618 618


    Visually this would be represented as (for identifier X):

    Capture.PNG

    Here green refers to Perf jobs and red refers to Cement jobs. Perfs would open the interval and cementing over a previously perfd interval would close it.

    I was hoping to be able to get a new list with current OPEN perfs for each of the identifiers. This is ensuring only unique values for perfs for a given well are shown taking into account any previous cement jobs that have closed the interval.

    New Table would have:

    IDENTIFIER DATE Job TOP BOTTOM
    X 1984-05-17 Perf 655.2 658.2
    X 1984-05-29 Perf 644 646
    Y 1994-03-25 Perf 621 625

    Thanks in advance!
    (Edited post with excel attachment)
    Attached Files Attached Files
    Last edited by lata_m; 11-28-2019 at 02:00 PM.

  2. #2
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Get unique values based on multiple criteria

    Maybe :
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important

+ 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. SUMIF - Based On Unique Values and Multiple Criteria
    By CreationUK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2019, 03:19 PM
  2. Count Unique values in multiple worksheets based on certain criteria
    By Kyuss21 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 03-06-2019, 01:09 PM
  3. Getting unique values based on Multiple Criteria
    By gclode in forum Excel General
    Replies: 3
    Last Post: 06-20-2016, 02:19 PM
  4. [SOLVED] List unique values based on multiple criteria
    By tangmere.milli in forum Excel General
    Replies: 6
    Last Post: 01-22-2016, 07:56 AM
  5. Reading unique values based on multiple criteria
    By bscheideman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-22-2015, 12:45 PM
  6. Count unique values based on multiple criteria
    By Jonathan11235 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-19-2015, 10:02 PM
  7. [SOLVED] Counting Unique/Different Values based on multiple Criteria
    By jdodz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2014, 05:41 PM

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