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 …
Formulas
Find the Closest Match in Excel (Nearest Value)
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
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?
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 …
How to Get the p-Value in Excel?
The p-value is an important statistical term in hypothesis testing. This value is one of the indicators that help decide whether a null hypothesis being tested can be rejected or …
Find Last Monday of the Month Date in Excel (Formula)
We often need to find the date corresponding to the last given weekday of the month. For example, you might need to know what date is the last Monday of …
How to Apply Short Date Format in Excel?
Working with dates in Excel might not be as simple as working with plain numbers and text, and the reason is that Excel’s way of storing and displaying dates is …
How to Extract Text After Space Character in Excel?
Data cleaning is probably the most common data pre-processing task. This becomes especially necessary when the data is imported from an external source, which was probably formatted differently. One of …
How to Convert Month Name to Number in Excel?
Converting a date to month name is quite common, but sometimes there may be a need to convert the month name to its corresponding month number. For example, you might …
How to Remove Duplicate Rows based on one Column in Excel?
One of the most common data cleaning tasks in Excel includes removing duplicate or redundant records/rows. While removing whole rows that are duplicate is straightforward, it’s a little trickier when …