I have a list of employees that I want to separate by supervisor name and whether they are active or terminated. The best way to do this is to use a two value index match formula witch I am doing but with some difficulty. It is just returning the first person on the list repeatedly instead of showing the next individual, then the next, then the next and so on. How do tell the formula to return the next item down on the list until complete?
In my example I am populating the test tab with the information on the data tab beginning in cell A7 on the text tab.
Bookmarks