VLOOKUP is used to transfer data between to data-sets that have a common identifier.
Read More
SUMIF and COUNTIF formulas are simple but effective formulas to aggregate specific data into a single cell.
Read More
This formula is used as a reliable/efficient lookup function.
Read More
The formula allows the user to test a specified scenario.
Read More
Used to identify whether or not a specific word is contained within a cell.
Read More
To get the unique/distinct values in a specific columns you have two options.
Read More