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. Presentation of COUNTIF The function COUNTIF requires only two parameters the range of cells where is your data the value you search …

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 the last update of your data

Too many data for the same contact Let’s start from this file where we have different informations about our clients. Sometimes, we have many different data 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 …

Continue reading »

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