Excel with Microsoft 365 has a PDF connector which enables us to extract data from PDF files. The beauty of this method is that the extracted data will automatically update for the changes in the source data. Let’s see how to extract the Tables in a PDF file using Power Query in Excel. Following is…
This tutorial is about 7 different methods to Remove Duplicates in Excel. I will be using the following data to explain the different ways to get rid of the records that repeat multiple times. Remove Duplicates tool in Excel The Remove Duplicates feature in Excel is the most popular tool for removing duplicates and is…
In this tutorial, I will show you 5 different ways to Extract only Numbers from a list of Strings. Following is a Table containing Text as well as Numeric Values and we will be using this data for explaining the different methods. FILTER Function to extract Numbers The ISNUMBER function in Excel can be used…
Following are 3 different methods to reverse text strings in Excel. Dynamic Array Formula to reverse Text The following formula combines the MID, TEXTJOIN, LEN and the SEQUENCE function to reverse the text string supplied into it. =TEXTJOIN(“”,1,MID(B3,SEQUENCE(LEN(B3),,LEN(B3),-1),1)) Let’s see what happens when we supply the text ‘Hana’ into the above formula. =TEXTJOIN(“”,1,MID(“Hana”,SEQUENCE(LEN(“Hana”),,LEN(“Hana”),-1),1)) Length of…
Following are 3 different ways to segregate Positive and Negative values from list of numbers in Excel. MAX and MIN Function to separate Positive and Negative values The MAX function in Excel will return the largest among 2 or more numbers supplied into it. This property of MAX function is used below to check whether…
In this blog post I will explain 3 different methods to find the Count of each Item in the list shown below. The methods include the use Pivot Table, Power Query and Formulas. Note that I have converted the list into an official Excel Table and named it as ABCD. Dynamic Array Formula to find…
This Excel tutorial is about 3 different methods to find the common values between two Lists or Tables in Excel. Here we have 2 lists of World’s Billionaires, one from the year 2015 and other one from 2020. Following are different methods to find the Names that are present in both lists. MATCH function to…
Calculate the Square of a Number The following are 3 different formulas to calculate the Square of the number in the cell B3 Formula 1 =B3*B3 Formula 2 =POWER(B3,2) Formula 3 =B3^2 Calculate the Square Root of a Number The following are 3 different formulas to calculate the Square Root of the number in the…
This article is about 3 different methods to Reverse a List in Excel. Following is a list of candidates applied for a job. Let’s see the different methods to reverse this list for scheduling the interview. 1. Reverse the list using a Helper column Create a helper column with sequential numbers (for example 1,2,3,..) adjacent…
In the previous post, I have explained How to Combine Data from Multiple Worksheets of an Excel Workbook. That was a crude method of static nature and won’t be the right choice, when you have plans to Add or Delete worksheets. The method explained here is recommended for those who want to Combine data from…
