hi there
I want to find persons first name from a range of full names data, and want to collect the information found, i.e how many times the persons name is in the range and paste the information in specific rows. the data is in this format
A B C D
1 title of book English Mathematics Chemistry
2 proof readers Mark John Michael Jackson John
3 Antonio Sara Khan Kiano Rieves
4 Matt Jimmy Wales Drew Houston
5 Phil Libin Ben Silbermann Mark
I want to add a formula next to the name's cell I want to search and find which books are proof reads by that person. i.e when I search Mark & Sara it will show me these results
A B
1 Mark English, Chemistry
2 Sara Mathematics
Kindly Guide me which formula to use.. and how
Bookmarks