Guys I need help in extracting data from a table.
Excel pic.jpg
eg.
A-team B-team D-team C-team
sam X X
pat X X
john X X
peter X
I want to know what are the teams in which sam a member. Peoples' names should be selected from a dropdown menu and names of the teams should be displayed below the menu in alphabatical order.
Can u help me?
Bookmarks