The most useful Statistics Excel functions
Excel offers many statistical functions that are easy to use. This article will show you how to use them to analyze your data.
COUNTIFS
COUNTIFS – Count rows automatically in Excel
The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.
Most common number in my spreadsheet
You can easily return the most common number in a range of cells with the function MODE or MODE.SNGL
Wildcard with COUNTIFS or SUMIFS
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
Function COUNTIF
The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.
Keep your Last Updated Data
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 […]
