In one worksheet i have many columns with information which is names and skills of that name in a corresponding row, I want to search and view this information, im using a match zero formula however I can only get one answer when I would like all of them. How can I achieve this?
hope someone can help
Bookmarks