+ Reply to Thread
Results 1 to 8 of 8

Filter data from table that have unique characteristics

  1. #1
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    233

    Filter data from table that have unique characteristics

    Hi, the original table is in blue. I would like an output table (in yellow) where only the non-duplicate unique types are in that output table. In other words, I don't want two columns with the same type (e.g. since column D is also type 27 like column C I don't want it ported to output table).

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Filter data from table that have unique characteristics

    Hi, have you tried using advanced filter?
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filter data from table that have unique characteristics

    Try PowerQuery

  4. #4
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    233

    Re: Filter data from table that have unique characteristics

    Thank you all for your comments. I am looking for a formula solution rather than something that needs manual clicking.

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Filter data from table that have unique characteristics

    With PQ you will do that one time but of course if you prefer formula(s)...
    good luck

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Filter data from table that have unique characteristics

    Quote Originally Posted by L.LEE View Post
    Thank you all for your comments. I am looking for a formula solution rather than something that needs manual clicking.
    Ok Try

    M1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    M2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy across
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  7. #7
    Forum Contributor
    Join Date
    12-22-2012
    Location
    Asia
    MS-Off Ver
    Microsoft 365
    Posts
    233

    Re: Filter data from table that have unique characteristics

    Thanks Shukla. Your formula works. sorry system does not allow me to add rep.

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Filter data from table that have unique characteristics

    Not an issue L.lee happy to help you and thanks for feedback

+ 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. filter table and copy unique value to mulitple sheets
    By matrix_xrs in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-08-2016, 09:36 AM
  2. Replies: 8
    Last Post: 06-26-2014, 02:37 PM
  3. [SOLVED] Unique item filter stops working when Table column is sorted?
    By e2Excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-25-2013, 01:17 PM
  4. Replies: 3
    Last Post: 03-21-2012, 02:08 PM
  5. Separating data with similar characteristics
    By oakman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2007, 02:25 PM
  6. Re-formatting data to use DATE-characteristics?
    By dune2 in forum Excel General
    Replies: 6
    Last Post: 08-08-2006, 09:34 AM
  7. filter unique data using functions
    By vrijbergen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2005, 06:05 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