Task board for the employees In the following document, we have the list of employees with tasks to perform. The team leader wants to build a series of dropdown lists to assign a task to one of the employees. But, the dropdown list should not display the names previously selected #1 Create a drop-down menu In this first step, there is nothing complicated. You have added a dropdown list to the cell. #2 Formula excluding the previously selected item To build this formula, we will use the FILTER and COUNTIF functions You must write the arguments in the correct order in […]
Create a depending drop down menu in Excel has become easier with the new functions FILTER and UNIQUE of Microsoft 365.