Tag Archive: COUNTIFS

Articles sur le thème : COUNTIFS

Function COUNTIF

If you need to count the number of rows corresponding to a name or a product, there is better than to use the filter. In fact, the COUNTIF function is dedicated for this. But the function COUNTIF accepts only one criteria of selection. If you want to count your row for more than one criteria, …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/countif/

Function COUNTIFS

Usefulness of the COUNTIFS function The COUNTIFS function allows you to count the number of rows corresponding to criteria. In fact, it's a bit like filtering your data and counting the rows that match your selection criteria. Except here, it's the function that returns this number for you 👍😍😎 COUNTIFS allows you to count between 1 …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/countifs/

Keep your last data update

Too many data entries for the same contact Let's start from a file where we store client information. Sometimes, we have many different data entries for the same customer. We want to keep only the newest information for each customer based on the column Update. Remove Duplicates not applicable With a such file, you can't …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/keep-last-update-data/