Forum Discussion
ecgrim
Jul 20, 2020Copper Contributor
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...
mathetes
Jul 21, 2020Gold Contributor
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