+ Reply to Thread
Results 1 to 2 of 2

List unique column values from table in new table

  1. #1
    Registered User
    Join Date
    10-22-2018
    Location
    USA
    MS-Off Ver
    Office 16
    Posts
    3

    List unique column values from table in new table

    I'm using the following formula to get the unique values of Column J from another sheet (named "Data") and listing those unique values in Column G on the current sheet.

    =IFERROR(INDEX(Data!$J$2:$J$71,MATCH(0,COUNTIF($G$21:G21,Data!$J$2:$J$71),0)),NA())

    Its working fine as is, but i would like to make a few tweaks and cant get it figured out.

    I'd like to:
    1. Only lost the unique values that show when the table is filtered.
    2. If possible, not have to set a Column G range in order to avoid blank (N/A, or just just unnecessary) rows in the new table.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    11-02-2016
    Location
    NY
    MS-Off Ver
    2010
    Posts
    459

    Re: List unique column values from table in new table

    I typically use Excel Advanced Filter. You can get a Unique set of values in a different column (my preference is to then sort the unique values- visually easier to work with). Go to the following tab: Data > (under sort & filter). Highlight your LIST RANGE, > click the radio button Copy to another location - then in the COPY TO pick where you want the new Unique values to go > Click the UNIQUE RECORDS ONLY check box > finally hit OK. It's fast an furious....I hope you like it.. 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] Create a list of unique values from several columns in a dynamic table.
    By schurchill39 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-28-2018, 06:51 PM
  2. Extract unique values in a column from a table
    By gandreso in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2017, 11:21 AM
  3. [SOLVED] Unique Values in List Using Imbedded MS Access table
    By Oxygen Potassium in forum Excel General
    Replies: 4
    Last Post: 10-26-2016, 02:18 PM
  4. [SOLVED] Data validation - unique list of table column values
    By michellepace in forum Excel General
    Replies: 6
    Last Post: 11-26-2015, 04:02 PM
  5. [SOLVED] UDF to List Unique Values Unsorted within a table
    By stu40 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-26-2015, 08:17 PM
  6. [SOLVED] Extract unique values from a table and list along a row
    By doctorblyth in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2013, 04:33 PM
  7. Replies: 1
    Last Post: 10-31-2013, 08:25 AM

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