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...
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- I just know that I will have many new values coming up soon and I'd like to automate the process of integrating them into my table. I suppose I will just do it manually as I come to them.
- ok. but if you take some time to learn power query, you may find that it can do what you want and save you time in the long run. It is quite powerful. You should be able to do the unique values and the counts all in PQ and output your table of values that you can sort.