VLOOKUP from Two or more Tables

The VLOOKUP function in Excel is designed to search for a ‘Lookup Value’ in the first column of the specified Table and return the corresponding Value against the first matching Value. But what if there are two tables, one of which has the possible matching value? A single VLOOKUP function can’t lookup into two different…

TEXTSPLIT and 13 New Functions in Excel

In this blog post, we will have quick look on the 14 New Functions added to Excel on the 3rd week of March 2022. They are TEXTSPLIT, TEXTAFTER, TEXTBEFORE, VSTACK, HSTACK, TOROW, TOCOL, WRAPROWS, WRAPCOLS, TAKE, DROP, CHOOSEROWS, CHOOSECOLS, and EXPAND The first 3 of these new functions TEXTSPLIT, TEXTAFTER, TEXTBEFORE are designed for manipulating…

How to find the Most Repeated Text or Number in Excel

This blog post is about different ways to find the ‘Most Repeated Number or Text’ in a data set. Formula to find the most repeated Number The MODE function in Excel is designed to return the most repeated number from a numeric dataset. An example with vertical data ranges. Another example with a 2 dimensional…

How to create a Gantt Chart in Excel

Gantt Chart is a horizontal bar chart used for project management and can visually represent a ‘Project Plan’ over ‘Time’. Gantt Charts can be used for scheduling Construction projects, Software development, Research & Design, etc., In this blog post, I will show you how to create a Gantt Chart using Microsoft Excel. Following is the…

How to Round Time in Excel

This Excel Tutorial is about rounding Time Up, Down and to Nearest 15, 30 or 60 minutes. Round Time Up The CEILING function in Excel will round a number up to the nearest multiple of a given number. This logic can be used to round time ‘up’ to the nearest multiple of given Minutes or…

How to import Text files into Excel

This blog post is about 4 different methods to import Text files into an Excel Worksheet. Open dialog To open a Text file stored in a specific location of your computer, go to the File tab of the Excel Ribbon > Open > Browse Open dialog will be activated. Use this dialog to locate the…

How to Add the Developer tab to Excel Ribbon

Microsoft Excel has a VBA interface and options related to that Programming interface are arranged in the Developer tab. But when you install Excel for the first time, you may not see the Developer tab in the Excel Ribbon. In this blog post, I will show you how to add the Developer tab or any…

Picture Lookup in Excel

Until now, Excel doesn’t have a lookup function that is designed to return a picture or pictures. That means there is no straight forward method for Picture Lookup in Excel. In this Excel tip tutorial, I will show you how to do Picture Lookup using the existing features in Excel. I have the list of…

How to create a Hyperlink to another Worksheet in Excel

In this blog post we will go through 3 different methods to create a Hyperlink to another Worksheet in Excel. Following is the data which we will be using to explain these methods. Given below is the Cost summary of a Highway Project and the Total cost is the consolidation of amounts from the Worksheets…

Count of a Weekday or Weekend between two Dates

This blog post is about an Excel formula which will return the Count of a particular Weekday or Weekend between two dates. The following formula will give us the Count of ‘Sundays’ between ’01/01/2022′ and ’31/12/2022′. =SUMPRODUCT(–(WEEKDAY(SEQUENCE(“31-12-2022”-“01-01-2022″+1,,”01-01-2022”))=1)) Let’s see how this formula works. Explanation of the Formula The SEQUENCE function will generate a list of…