Forum Discussion
Updating unique values in a table
I understand that spill formulas like the UNIQUE function are not supported inside of a table, but I need to find a way to update a specific table anytime new unique values are added to the main data set that my table is referencing.
I have created a static list of unique names already, and I have some COUNTIFS formulas returning relevant data based on those items, but I need to find a way to automatically update my table with new unique names if they are added to the reference data set. Can this be done?
6 Replies
- easiest way would be to use the UNIQUE to make that list dynamic instead of using a static list. Otherwise you would have to create a more complicated UNIQUE to exclude the static list.
- My problem is that I cannot use the UNIQUE function inside of a table. I built my current table using the UNIQUE function, but then was forced to convert it to static data before plugging it into the table. If I didn't have to sort my data at all, I would just use it without being in a table, but I do, so I cannot.
- what about using a pivot table instead? or Power Query?
i could create a UNIQUE function to find new items but as you noted that couldn't be in the table so you would still have to manually add them
