Forum Discussion
Solved
Excel using Unique() and Formula Auto-FIll
Hello Everyone, I am using Unique on a table of about 10,000 entries. It returns a list and I want to then perform sumproducts and other functions against this list of unique values. This solutio...
As variant two spills
left
=UNIQUE(Table1[[Fruit ]])right
=SUMIFS(Table1[[ Qty]],Table1[[Fruit ]],UNIQUE(Table1[[Fruit ]]))
As variant two spills
left
=UNIQUE(Table1[[Fruit ]])right
=SUMIFS(Table1[[ Qty]],Table1[[Fruit ]],UNIQUE(Table1[[Fruit ]]))
SergeiBaklan Has anyone offered you a kind word today? You sure deserve one. I cannot believe how simple and elegant your solution is. Thank you for sharing your knowledge with me. I can't wait for these functions to work in tables, it's so much nicer to read table references than array references. You're my hero for the day!
MLHansen , you are welcome, glad to help