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...
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.
Thanks. I'll take a look into it!