+ Reply to Thread
Results 1 to 3 of 3

Formula to autofill table with unique entries anytime additional data is added to dif file

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    12

    Formula to autofill table with unique entries anytime additional data is added to dif file

    Hi,

    I have data that I will be adding to a table used in Power Pivot.
    I am looking to create a formula that will automatically pull any distinct entries off of one column of this data and add it to another table

    e.g. in the given list, the source data is tab 'CC test data' and the table is on 'CC Claim ID'

    I am looking for the table to automatically populate with any new unique data that is added to 'Claim ID' Column L that is added to Tab 'CC test data'
    As an example, if the original data was Rows, 1:8, the Table is accurately populated (h344, h5885, and h6234 have only been recorded once).
    If I were to add on the data in columns 16:18, I am looking for the data in Table on tab 'CC Claim ID' to automatically add h129 and h5565.

    The data is updated several times per a day, so I prefer to automate this and keep away from advanced filters etc.
    This data will then be drawn from for use in Power Pivot relationships.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,769

    Re: Formula to autofill table with unique entries anytime additional data is added to dif

    As you have Office 365 look at UNIQUE function (?)

  3. #3
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,369

    Re: Formula to autofill table with unique entries anytime additional data is added to dif

    Yes, you could use:

    =UNIQUE('CC test data'!L2:L18)

    (if you could put your "CC test data" in an excel table, you could reference the table column and that would be best.)
    If you want to NOT display 0's, an option would be to do this:

    =LET(a,UNIQUE('CC test data'!L2:L18),FILTER(a,a<>0))

+ 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. Array formula fails when additional column of data added
    By sipa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-19-2020, 06:40 PM
  2. Insert additional check boxes (ActiveX) to worksheet if more rows of data are added
    By Andrewstupendo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2016, 05:49 PM
  3. copy formula and paste for new data added and autofill.....and paste special values
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2014, 07:40 AM
  4. [SOLVED] Additional criterion date function to be added to existing formula
    By Christopherdj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2012, 02:07 AM
  5. Replies: 1
    Last Post: 01-28-2010, 07:45 PM
  6. Exporting Excel Sheet With Additional Info Added To A Text File
    By SouthernBoy718 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-12-2008, 05:51 PM
  7. finding unique entries as added
    By CADSteve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-03-2007, 10:48 AM

Tags for this Thread

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