Excel IF

Removing Non Numeric Characters

This post will guide you how to remove non numeric characters from cells with a formula in Excel. How do I remove non-numeric characters in cells in Excel. How to remove non-numeric characters from cells with VBA Code in Excel. Or how to strip out non-numeric characters from a given cell in Excel. Removing Non… read more »

VLOOKUP Return Multiple Values Horizontally

This post will guide you how to vlookup a value and then return multiple corresponding values horizontally in Excel. How do I lookup a value and return multiple matched values in the same row in Excel. Or how to return multiple values with VLOOKUP function in Excel. VLOOKUP Return Multiple Values Horizontally Assuming that you… read more »

Excel Vlookup From Another Workbook

This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup From Another Workbook Before we use the VLOOKUP function to look for a value in… read more »

Excel Vlookup Return True or False

This post will guide you how to vlookup values in a range of cells and then return True or False values in Excel. How to use the VLOOKUP function to vlookup a value in a list of data, and return True or False values in a selected cells. In Excel, you can use the VLOOKUP… read more »

Compare Dates

This post will guide you how to compare dates if it is greater than a given date in excel. How do I compare a list of dates with a specified date using a formula in Excel. Compare Dates Assuming that you have a list of data that contain date values in Excel, you can use… read more »

Count Unique Values Using Pivot Table

This post will guide you how to count unique items in Excel Pivot Table. How do I use Pivot Table to count unique distinct values in Excel. How to get a distinct count in a pivot table in Excel. Assuming that you have a list of 5 cells with 3 unique values, and you want… read more »

Show Only Positive Values

This post will guide you how to show only positive values in an excel formula. How to show formula result only if it is a positive value in excel. Is there a way to have a formula return only positive numbers in excel. Show Only Positive Values Assuming that you have a list of data,… read more »

Comparing Columns Using Conditional Formatting Icon Sets

This post will guide you how to compare the adjacent cells in the different columns using Conditional Formatting Icon Sets in Excel. How do I compare cells in the adjacent rows using Conditional Formatting Icon Sets in Excel. How to compare Columns or rows using Conditional Formatting Icon Sets to show increase or decrease status… read more »

Create a Five Star Rating System

This post will guide you how to create a five star rating system in your current worksheet in excel. How do I change the five points system to five star rating in excel. How to use the conditional formatting function to create a five star rating system in excel. Create a Five Star Rating System… read more »

Find the Largest Value Based on Multiple Criteria

This post will guide you how to find the largest value based on one criteria in excel. How do I return the largest value based on multiple criteria in excel. How to find and return the largest value based on one criteria and multiple criteria with formula in excel. Find Largest Value with multiple Criteria… read more »

Sidebar