'CHOOSE function' category
How to use the CHOOSE function
The CHOOSE function lets you get a value based on a number, the number determines which value to get. The […]
The CHOOSE function lets you get a value based on a number, the number determines which value to get. The […]
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
How to group items by quarter using formulas
This article demonstrates two formulas, the first formula counts items by quarter and the second formula extracts the corresponding items […]
This article demonstrates two formulas, the first formula counts items by quarter and the second formula extracts the corresponding items […]
How to perform a two-dimensional lookup
Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]
Table of Contents How to perform a two-dimensional lookup Reverse two-way lookups in a cross reference table [Excel 2016] Reverse […]
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