Currently, I use Excel Power Query to list unique items from a list.
It works fine in Desktop version of Excel 2016. However, in the free online version the Power Query can't be refreshed.
What other solutions are there for this? (maybe a formula that works in Excel 2016.