Forum Discussion
Summing specific values within a range based on dynamic inputs
Hello, Suppose I have a table with four columns: ID Number, Color, Country, and Price, and maybe 1000 rows. ID numbers may not be unique. I also have 3 separate cells to control parameters - one ...
Thank you! I don't think my version of excel (365 home) has power query functionality built in. Is trying to do this with formulas impossible in your view?
Tom,
if your subscription is based on Excel 2016 then PQ is now a part of Excel. It can be found under "Get and transform".