'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 […]
Time sheet for work
I have built a sheet to track time at work. It is very simple, there are 13 sheets, one for […]
Filter duplicates within same date, week or month
The image above demonstrates a formula in cell E3 that extracts duplicate items if they are on the same date. […]
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 […]

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