Forum Discussion

ecgrim's avatar
ecgrim
Copper Contributor
Jul 20, 2020

Alternative to Power Query

Looking for suggestions for how to pull all data from one worksheet to another based on a value in one or two columns. I thought I might be able to do this with Power Query but I use a Mac and that d...
excel
Excel on Mac
Formulas and Functions
mathetes's avatar
mathetes
Gold Contributor
Jul 21, 2020

ecgrim 

 

If you have the newest version of Excel on your Mac, the FILTER function will perform exactly what you want.

 

And if you add SORT, it would put them into alphabetical order (or reverse) based on a column of your own choosing.

 

If rather than an image you'd upload the actual sample spreadsheet, I or somebody else could demonstrate. But my guess is that you can figure it out. In fact, to help, here's a YouTube video that covers these new functions.  https://www.youtube.com/watch?v=9I9DtFOVPIg

 

  • ecgrim's avatar
    ecgrim
    Copper Contributor
    Jul 21, 2020

    Thanks mathetes! I appreciate your guidance. If you have time, I would love a demonstration. I will also watch the video you provided.

    • TheAntony's avatar
      TheAntony
      Iron Contributor
      Jul 21, 2020

      ecgrim , Here's the Filter function in action. I converted the original data into a Table to make the solution more robust. Hope this helps.

Resources