'HSTACK function' category



How to use the HSTACK function
What is the HSTACK function? The HSTACK function lets you combine cell ranges or arrays, it joins data to the […]
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 […]
Group rows based on a condition
What's on this page Group rows based on a condition Merge matching rows 1. Group rows based on a condition […]
Fuzzy lookups
In this post I will describe a basic user defined function with better search functionality than the array formula in […]
Fuzzy VLOOKUP
This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.
Sort rows based on frequency and criteria
Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]

Excel categories