Jul 20 2020 04:11 PM
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 does not appear to be supported. Very simplified example attached. (I am not interested in using a program to run a Windows environment on my Mac)
Jul 20 2020 05:43 PM
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
Jul 20 2020 06:01 PM
Thanks @mathetes! I appreciate your guidance. If you have time, I would love a demonstration. I will also watch the video you provided.
Jul 20 2020 06:19 PM
@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.