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 […]
Keep the last updated row Let's start from a file storing customer information. Some customers have multiple records in the file, as a new record was created each time they changed their address or phone number. How do you keep only the last updated row? 🤔🤨 Remove duplicates not applicable With a such file, you can't use the tool Remove Duplicate. Well, you can use it but the tool will remove nothing. Why? It's because each row has something different. Like the phone number or the address 🧐 Step 1: Use the formula COUNTIFS Firstly, we are going to count […]