+ Reply to Thread
Results 1 to 4 of 4

How to filter two column values

  1. #1
    Registered User
    Join Date
    03-20-2024
    Location
    boston,ma
    MS-Off Ver
    365
    Posts
    2

    How to filter two column values

    Not sure if I can articulate what I want to achieve in a single sentence, but I will try.
    Please see attached screenshot.
    I want to see only those id's that are on the same date .
    Eg id 12(whites) has 3 entries . Two on 3/20/24 and one on 3/10/24.
    I want to see only the two entries that have the same date and not the one on 3/10/24.
    Others that are like this are 14(rose), 22(reds), 18(maxima).

    I have huge data where I have to retrieve the id's that have combination of codes
    99396 with 99213,99212,99204,99214,99215 but fall on the same date.

    I have idea how to go about getting this .

    Any help much appreciated.
    Screenshot 2024-03-20 201744.jpg
    Last edited by mrtractor; 03-20-2024 at 08:20 PM.

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How to filter two column values

    Use this formula.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by DJunqueira; 03-20-2024 at 10:46 PM.

  3. #3
    Registered User
    Join Date
    03-20-2024
    Location
    boston,ma
    MS-Off Ver
    365
    Posts
    2

    Re: How to filter two column values

    DJunqueria, Thank you so much! Much appreciated!

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: How to filter two column values

    Tks for the feedback and welcome to the forum.

+ 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. Replies: 6
    Last Post: 10-30-2022, 09:42 AM
  2. Replies: 12
    Last Post: 09-23-2019, 04:30 PM
  3. [SOLVED] PivotTable: filter to only include top five of values in a values column
    By adh2 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-03-2015, 02:02 PM
  4. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  5. [SOLVED] Filter rows based on unique values in one column + specific value in another column
    By Dieneces in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 09:55 AM
  6. Replies: 3
    Last Post: 11-24-2008, 01:10 PM
  7. [SOLVED] Advanced Filter for Values in Column M greater than Values in Colu
    By SteveC in forum Excel General
    Replies: 3
    Last Post: 05-02-2006, 03:00 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