Skip to content
Spreadsheet Planet
  • About
  • Excel Tips
  • Formulas
  • Charts
  • VBA / Macros

Formulas

Get Unique Values from a Column in Excel – 3 Easy Ways!

Get Unique values from a column in Excel

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 …

Read more

Weighted Average Formula In Excel (Easy Examples)

Weighted average formula Excel

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 …

Read more

How to Separate Names in Excel (5 Easy Ways)

How to separate names in Excel

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 …

Read more

Compound Interest Formula in Excel (2 Easy Ways)

Compound Interest formula in Excel

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 …

Read more

How to Calculate Percentage Difference in Excel (Formulas)

Calculate Percentage Difference in Excel

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 …

Read more

SPILL Error in Excel – How to Fix?

SPILL Error in Excel

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 …

Read more

Extract Last Name in Excel – 4 Easy Ways!

Extract Last Name in Excel

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 …

Read more

Find the Closest Match in Excel (Nearest Value) – Easy Formula

Formula to find closest match in Excel

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 …

Read more

Count the Number of Yes in Excel (Using COUNTIF)

Count Yes in Excel

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 …

Read more

Remove Parentheses (Brackets) in Excel – 3 Easy Ways

Remove parenthesis from text

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, …

Read more

How to Enter Sequential Numbers in Excel? 4 Easy Ways!

Enter sequential numbers in Excel

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 …

Read more

How to Flip Data in Excel (Columns, Rows, Tables)?

Flip Data in Excel - Rows Columns and 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 …

Read more

Post navigation
Older posts
Page1 Page2 … Page6 Next →

Most Popular Articles

How to Compare Two Columns in Excel (using VLOOKUP & IF)

Multiple If Statements in Excel (Nested Ifs, AND/OR) with Examples

How to Remove Dashes (-) in Excel?

How to Center the Worksheet Horizontally on the Page in Excel

How to Merge First and Last Name in Excel

How to Remove Commas in Excel (from Numbers or Text String)

Why does Excel Open on Startup (and How to Stop it)

How to Remove Apostrophe in Excel

How to Unsort in Excel (Revert Back to Original Data)
SpreadsheetPlanet.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

2022 © SpreadsheetPlanet.com Privacy Policy | Sitemap

DMCA.com Protection Status