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

[Mr Stern 2]

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.

[JohnTopley]

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

[Gregb11]

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))