I had a fair grasp on using Excel about 8 years ago. Now, with all this extra free time at home, I've trying to refresh my brain cells again with a pretty simple problem.
I have a family tree worksheet with a long list of ancestors and a second worksheet to allow me to input just a First and Last name and hopefully, display any and all rows in the family tree worksheet that match the names I enter.
I could really use some advice on how to go about creating a simple array to gather those matches.
Excel (Office 365)
Bookmarks