'ABS function' category

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 […]
Calculate the number of weeks between given dates
This article demonstrates Excel formulas that calculate complete weeks between two given dates and weeks and days between two given […]
Count rows containing data
Table of Contents Count rows with data Count non-empty rows Count cells between two values Count cells based on a […]
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 […]
Split expenses calculator
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 […]
Count cells between specified values
This article demonstrates formulas that calculate the number of cells between two values, the first scenario involves two search values […]
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 […]
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 […]
Lookup the nearest date
Table of Contents Lookup the nearest date Lookup min max values within a date range 1. Lookup the nearest date […]
Find closest value
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

Excel categories