Tag Archive: COUNTIFS

Articles sur le thème : COUNTIFS

Function COUNTIF

COUNTIF

A basic task with Excel is to count the number of rows for a specific criteria. Solution with the filter Most of the Excel users, use the filter to count the rows. But this solution is really not convenient when you have to repeat this action for many values. The solution is to use COUNTIF …

Continue reading

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

Count rows automatically in Excel

Avoid the filter to count rows When you want to count the number of rows corresponding to a specific criteria, many users use the tool Filter. For 1, 2 or 3 different criteria, you can work like that. But if you have to extract a lot of count of rows for many different criteria, the …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/count-rows-automatically-in-excel/

Keep your last updated data

Keep the last updated row Let’s start from a file where we store customers informations. Some customers are many times in your file when they change their phone number or address 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. …

Continue reading

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