Hi i know this is a pretty basic problem but for the life of me i cant search for the right solution.
I have two columns one with names and the second with emails.
Names Emails
Ben b@b.com
James j@gov.au
Rick rick@gov.au
What i want is to find all emails with .gov.au in them and then select the cells on the left of those emails that contain the corresponding names
That way i can copy them into a new sheet.
Any help at all would be much appreciated theres 6000 records and selecting them individually will be a pita!
Thanks.
Bookmarks