Thanks in advance for any comments,
I need this help badly.
I have three columns
Company | Rank | Name
and I have data
What is the formula if I want the name of the person of specific rank (I will refer a cell as the input) of a specific company (I will refer a cell to get this data). Image and excel file attached.
Capture.PNG
Bookmarks