Forum Discussion

Copper Contributor

Feb 14, 2019

How to return multiple results based on multiple criteria

I'd like to return data from multiple worksheets based upon multiple criteria. Here is an example: Data Table 1 (in worksheet 1) Item Location Qty this east 5 that west 10 anothe...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Feb 14, 2019

Instead of macro that could be done by Power Query - query all your tables, combine them, filter on criteria and land the result back to the sheet.

Andrew Lindsay

Copper Contributor

Feb 18, 2019

Sergei, Power Query may be the way for us to go. I see it will perform the functions we need. However, although our company has access to Power BI through our Office 365 for Business subscription, I'm not sure that our client has access. I haven't reviewed the material on the functionality, but if I understand correctly workbooks we create using the Power Query functionality won't be able to be used by another unless they also have an Office subscription that contains the functionality. Is this correct?

Thanks again,
Andrew

SergeiBaklan
Diamond Contributor
Feb 18, 2019
Hi Andrew,

More exactly they won't be able to update the query. You may check where PQ is available here https://support.office.com/en-us/article/where-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16
- Andrew Lindsay
  Copper Contributor
  Feb 18, 2019
  Sergei, thank you. I will check on this.
  - Twifoo
    Silver Contributor
    Feb 19, 2019
    Focus your attention on Sheets 4 and 5 of the file I attached earlier. Then, update me of your thoughts thereon.