## 'ABS function' category

Date and Time Functions – A to M

Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]

Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE […]

How to use the asterisk character

The asterisk character allows you to multiply numbers and boolean values in an Excel formula. It can also be used […]

The asterisk character allows you to multiply numbers and boolean values in an Excel formula. It can also be used […]

How to use the ABS function

What is the ABS function? The ABS function converts negative numbers to positive numbers, in other words, the ABS function […]

What is the ABS function? The ABS function converts negative numbers to positive numbers, in other words, the ABS function […]

Count cells containing text from list

Table of Contents Count cells containing text from list Count entries based on date and time Count cells with text […]

Table of Contents Count cells containing text from list Count entries based on date and time Count cells with text […]

Split expenses calculator

This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]

This article demonstrates two ways to calculate expenses evenly split across multiple people. The first one is a formula solution, […]

Find numbers closest to sum

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Identify numbers in sum using Excel solver

Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]

Table of Contents Identify numbers in sum using Excel solver Find numbers in sum - UDF Find positive and […]

Find the most recent date that meets a particular condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

How to create date ranges in Excel

Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 […]

Question: I am trying to create an excel spreadsheet that has a date range. Example: Cell A1 1/4/2009-1/10/2009 Cell B1 […]

Find closest value

This article demonstrates formulas that extract the nearest number in a cell range to a condition. The image above shows […]

This article demonstrates formulas that extract the nearest number in a cell range to a condition. The image above shows […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values