'WEEKNUM function' category
How to use the WEEKNUM function
What is the WEEKNUM function? The WEEKNUM function calculates a given date's week number based on a return_type parameter that […]
What is the WEEKNUM function? The WEEKNUM function calculates a given date's week number based on a return_type parameter that […]
Time sheet for work
The image above shows how to summarize work hours using the new GROUPBY function in Excel 365. This is demonstrated […]
The image above shows how to summarize work hours using the new GROUPBY function in Excel 365. This is demonstrated […]
Extract a list of duplicates from a column
The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]
The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]
Count unique distinct values
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
This article describes how to count unique distinct values. What are unique distinct values? They are all values but duplicates are […]
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