Results 1 to 2 of 2

Thread: Scrub Excel table to show only listed criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2014
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Scrub Excel table to show only listed criteria

    I have an Excel sheet with over 21,030 records (rows), that need to match against a List sheet with by two criteria. Criteria 1 = WUC and Crtieria 2 = POS. How can I vet the list to show only the listed criteria items? Also, list the criteria items not in the list being vetted? The List tab is the criteria and Physical Installed is the list being scrubbed.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,936
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Scrub Excel table to show only listed criteria

    How can I vet the list to show only the listed criteria items?
    Employ the filter that is on the Data Tab. Highlight your data and then filter the column for your items.

    https://support.office.com/en-ie/art...6-38c37dcc180e
    Last edited by alansidman; Jun 9th, 2019 at 09:52 AM.
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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