Latest Posts

Excel Count Number of Occurrences of Each Value in a Column

For performing different tasks in Excel you may need to count the occurrence number of each value. Agenda for this article is to show you how to ...

COUNTIF with Multiple Criteria in Different Columns in Excel

Microsoft Excel has provided very useful & common functions named COUNTIF & COUNTIFS to count cells under multiple criteria in different ...

Excel round to nearest 10000 (5 Easiest Ways)

Rounding is necessary when we deal with numbers. In Excel, we can easily round numbers to any specific value using different functions. In this ...

How to Split One Cell into Two in Excel (5 Useful Methods)

When you import data from a database or any other sources, you have to split cell one into two or more in such situations. In this tutorial, I’m ...

How to Extract Unique Values Based on Criteria in Excel

Extracting unique values based on single or different criteria is very common in office & business. Microsoft Excel has also added a few useful ...

If Cell Contain Word Then Assign Value in Excel (4 Formulas)

If you want to assign value to a cell based on a certain word in another cell then you'll need to build a formula because Excel doesn't provide a ...

How to Find Unique Values from Multiple Columns in Excel

Today I will be showing how you can extract unique values from multiple columns in Microsoft Excel. Download Practice Workbook How to Find ...

Excel Formula Count Unique Values (3 Easy Ways)

Working with a large dataset in Excel, you may often need to know how many duplicate and unique values are there. You are definitely not going to ...

How to Separate Numbers in Excel Using Formula (5 Ways)

Sometimes we may need to separate or get only numbers from any text and number combined input. Without doing this manually Excel provides various ...

Excel Formula If Cell Contains Text Then Return Value in Another Cell

One of Excel's most popular tasks is to check if a cell has a value based on a given condition. This value may be text, date, or any other numeric ...

How to Round up Decimals in Excel (4 Simple Ways)

Microsoft Excel has provided a number of very easy, quick & useful methods to round up the decimals to a particular point or limit. In this ...

How to Round Off Numbers in Excel (4 Easy Ways)

Excel is an excellent tool for performing mathematical calculations. It comes with a number of built-in functions that simplify this process. One of ...

Excel if One Cell Equals another then Return another Cell

MS Excel provides various options and methods to make our tasks easier. In this article, I will show some ways if we want to check cells one with ...

How to Round to Nearest 5 in Excel (3 Quick Ways)

Today I will be showing how you can round any number to its nearest multiple of 5 in Microsoft Excel. Download Practice Workbook How to ...

Excel Round to 2 Decimal Places (with Calculator)

For different purposes you may need to present a number rounded up to 2 decimal places. Our agenda for today is to show you several ways to round ...

ExcelDemy
Logo