Operations in Excel
Excel
How to Solve a System of Equations in Excel (3 Examples)
To solve a system of equations in Excel, we can use the MMULT and MINVERSE functions.
The following examples show how to use these functions...
Excel
How to Count Duplicates in Excel (With Examples)
Often you may want to count the number of duplicate values in a column in Excel.
Fortunately this is easy to do and the following...
Excel
How to Compare Two Lists in Excel Using VLOOKUP
You can use the following basic formula to compare two lists in Excel using the VLOOKUP function:
=ISNA(VLOOKUP(A2,$C$2:$C$9,1,False))
Using the Conditional Formatting tool in Excel, we...
Excel
How to Ignore #N/A Values When Using Formulas in Excel
You can use the following basic syntax to calculate the mean, median, sum, standard deviation, etc. in Excel while ignoring #N/A values:
=AVERAGE(IFNA(A2:A21, ""))
=MEDIAN(IFNA(A2:A21,...
Excel
How to Replace #N/A Values in Excel (With Examples)
You can use the following basic syntax to replace #N/A values in Excel with either zeros or blanks:
#replace #N/A with zero
=IFERROR(FORMULA, "0")
#replace #N/A with...
Excel
How to Rank Items by Multiple Criteria in Excel
You can use a combination of the RANK.EQ() function and the COUNTIFS() function in Excel to rank items by multiple criteria.
The following example shows...
Excel
How to Perform Cluster Sampling in Excel (Step-by-Step)
In statistics, we often take samples from a population and use the data from the sample to draw conclusions about the population as a...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read