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 ]]))
Hi MLHansen,
May you can try constructing the formula this way
=SUMIF(Table1[Fruit],D2#,Table1[Qty])
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
ExcelExciting Well both solutions work, that's awesome. I assume what I'm trying to do is get an equal length spill into the equations to generate the dynamic length correct? So any "spill" will work here. I think I'm gonna run with your solution as unique() likely has a larger overhead and my data set does take take time to iterate over. Thank you kindly!
MLHansen, glad to her your query is resolved & found our solution helpful. don't forget to marking the solution as best answers
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com
