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 how many times we have the same ID. An ID is a unique value that identifies a person, a product, .... The function to count rows is the function COUNTIFS. The ID in our example is the email address. To solve our problem, THERE IS A TRICK π‘π§ We must […]
You can create complex criteria in your COUNTIFS or SUMIFS function with the wildcart.The wildcards are specials characters to replace one or more characters in your string