Resources
How to find number of days in a month
This article shows you how to find number of days in a month to make your month-driven calculations dynamic. DAY and EOMONTH functions help us for this tip. Syntax =DAY(EOMONTH(Date, 0)) Steps Start with =DAY( Continue with EOMONTH( Select or type the...
How to make case sensitive match
If your data is case sensitive, you may have issues finding correct matches with lookup functions. This How to make case sensitive match article shows you how to combine MATCH and EXACT functions to achieve case sensitive matching. Syntax { =MATCH(TRUE,...
How to check if a value exists in a list
The logical tests and conditional checks have important role in Excel models. Potential errors can be detected and handled by using the right logical tests. If you know How to check if a value exists in a list, you can use this logical statement to detect...
How to find smallest value in array using a criteria
This article shows how to find smallest value in array using SMALL and IF functions in an array formula. Syntax {=SMALL(IF(criteria range = criteria, data range reference), nth)} Steps Start with =SMALL( function Continue with IF( Type the criteria...
How to find nth smallest value in a data table
This article shows you how to find nth smallest value in a data table by using the SMALL function. Syntax =SMALL(absolute data range reference, nth) Steps Start with =SMALL( function Select the range that contains the values $B$2:$G$7, Select the cell that...
How to count values by length
This article shows how to count values by length based on their character count. This method can be helpful to check your data against invalid entries. It is also a good practice to use SUMPRODUCT and N functions together. Syntax...
How to count years between two dates with the DATEDIF
This article show you how to count years between two dates using the DATEDIF function. Syntax =DATEDIF(start date, end date, "y") Steps Use =DATEDIF( Select or type range reference that includes start date B3, Select or type range reference that includes...
How to count months between two dates with the DATEDIF
This article show you how to count months between two dates using DATEDIF function. Syntax =DATEDIF(start date, end date, "m") Steps Use =DATEDIF( Select or type range reference that includes start date B3, Select or type range reference that includes end...
How to SUM 2d ranges with SUMPRODUCT
Summing values by a condition may sound easy. If not, please see Crunch Data Even Faster with the SUMIFS Function article as well. You can easily sum values by condition(s) with SUMIF and SUMIFS functions; with a limitation. The sum range and criteria...