Get Unique Values from a Column in Excel – 3 Easy Ways!
Unique values are those that appear on a list just once. When working with data in Excel, you will often come across datasets that have duplicates in the column and …
Formulas
Weighted Average Formula In Excel (Easy Examples)
You might come across some data distributions where different quantities carry different levels of importance (or weightage). A standard average is not really a good representation of such distributions, since …
How to Separate Names in Excel (5 Easy Ways)
Performing operations on names like search, sort, filter, etc. is usually easier when full names are separated into separate columns. In fact, separating names is such a frequently performed data …
Compound Interest Formula in Excel (2 Easy Ways)
Compound interest is a concept heavily used by the banking and finance industry. If you’re investing or saving money in a bank, Compound Interest is the magical formula that is …
How to Calculate Percentage Difference in Excel (Formulas)
The term ‘percentage difference’ is often misunderstood. A lot of people get mixed up between the terms ‘percentage difference’ and ‘percentage change’. Both are completely different concepts and have completely …
SPILL Error in Excel – How to Fix?
If you’re using Excel 365 or newer versions, you might have come across the SPILL error. This is a new error code that you will find in addition to the …
Extract Last Name in Excel – 4 Easy Ways!
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list. For example, we …
Find the Closest Match in Excel (Nearest Value) – Easy Formula
There are enough functions in Excel to help you if you need to find an exact match for a value from a list. However, if you’re looking to find the …
Count the Number of Yes in Excel (Using COUNTIF)
Excel is quite commonly used in processing survey data and results. In many cases, these surveys are used to collect user responses as Yes or No. and then as part …
Remove Parentheses (Brackets) in Excel – 3 Easy Ways
The parentheses are a pair of symbols that have different meanings in different contexts. In general, parentheses are used to group elements together into an entity. In the English language, …
How to Enter Sequential Numbers in Excel? 4 Easy Ways!
Sequential numbers are an ordered list of consecutive numbers. It can sometimes be needed to have your rows numbered with sequential numbers. For example, if you have a dataset of …
How to Flip Data in Excel (Columns, Rows, Tables)?
When trying to flip data, be it a column, row, or table in Excel, you would probably find that there’s no built-in option to do this. If your data is …