Latest Posts From Shakil Ahmed
Understanding the Scenario Let’s start with a basic example. Imagine we have a table with product names and their revenues over five months. We want to find ...
Shakil Ahmed
This is the sample dataset. Example 1 - Use Greater Than in the IF Function Steps: Select F5 and enter the following formula. ...
To demonstrate methods for sorting rows in Excel, we’ll utilize this simple dataset listing several footballers and their goals scored over the last five ...
We have a simple table having a few random Persons from different Countries and their respective Favorite Sports and Favorite Player. We will filter ...
Method 1 - Employ Sort Feature 1.1 Sort Alphabetically Without Empty Column Steps: Select any of the column cells that you want to sort. Sort based on ...
The DIR function in VBA mainly shows you the directory or the files from a given folder. It can also return the first file with this function. This function ...
Excel provides several VBA functions that can be used while writing a macro or to define your own function to perform your desired tasks. In this article, we ...
How to Launch the VBA Editor in Excel If you don’t see the Developer tab, enable the Developer tab. Select the Developer tab and click on Visual Basic. ...
This is an overview. The ISNA Function in Excel The ISNA function is an INFORMATION function in Excel. It checks whether a cell contains the #N/A ...
Introduction to the Excel TRIM Function The Excel TRIM function is categorized under the TEXT functions. It removes the extra spaces from a text string. ...
In this article, we will demonstrate some uses of the SUBSTITUTE function with examples. Excel SUBSTITUTE Function: Quick View Introduction to ...
Fortunately, there are several text functions in Excel to help you perform your desired tasks easily and swiftly. Today, we are going to show you how to use a ...
Method 1 - Basic Use of LEFT Function: Extract String from Left Side Steps: Select Cell D5 and insert the following formula. =LEFT(B5,4) ...
Overview of the MAX Function Introduction to MAX Function in Excel The MAX Function is categorized under Excel STATISTICAL functions. This function ...
Excel provides several statistical functions to help you perform tasks easily and swiftly. Today we are going to show you how to use a statistical function ...
See Our Reviews at
Bob, PivotTable is one of the prime features of Excel, so regardless of the version (contemporary versions) you should get it inside the “Insert” tab of the ribbon. But if you don’t find that there you may need to customize your ribbon. Click on File > Options, then follow the image
And if counting unique is your main goal right now you might get that using the UNIQUE function (and COUNT family function for counting).
Thanks for commenting Merle, glad to hear that it helped you.