'UPPER function' category
How to use the UPPER function
What is the UPPER function? The UPPER function converts letters in a value to upper case letters. What are upper […]
What is the UPPER function? The UPPER function converts letters in a value to upper case letters. What are upper […]
Working with classic ciphers in Excel
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]
Count specific multiple text strings in a given cell range
This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range. The […]
This article demonstrates an array formula that counts how many times multiple text strings exist in a cell range. The […]
Fuzzy lookups
In this post I will describe a basic user defined function with better search functionality than the array formula in […]
In this post I will describe a basic user defined function with better search functionality than the array formula in […]
Count how many times a string exists in a cell range (case insensitive)
Question: How do I count how many times a word exists in a range of cells? It does not have […]
Question: How do I count how many times a word exists in a range of cells? It does not have […]
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