Forum Discussion
gaylemitchell
Mar 02, 2023Copper Contributor
Copy and paste results from Find and Replace on Mac
Hello! I need to sort specific emails addresses out of a list in Excel. I used Find to locate them by their @organization and get the results I need. But then I can't do anything with them. I can sel...
mathetes
Mar 02, 2023Gold Contributor
If you have a new version of Excel, the FILTER function should be able to do what you want. Here's a link that describes in quite a bit of detail how it works.
If you need more assistance, perhaps you could post a mockup of your actual workbook (no real names or addresses) on OneDrive or GoogleDrive, with a link here that grants edit access.
gaylemitchell
Mar 07, 2023Copper Contributor
mathetes Thank you for your help! I eventually figured it out once I had another more experienced set of eyes on it.