Shakil Ahmed

In this tutorial, I am going to show you 6 easy methods on how to compare two strings for similarity in Excel. You can use these methods even in large datasets ...

For different purposes, you may need to find the top n number of values in Excel, n can be 5 or 10, and many more. Now, today we are going to show you how to ...

You may have used the MIN and the MAX functions separately in Excel many times. But when it matters to use the functions within the same formula, you might be ...

Microsoft Excel is a powerful program where we can perform numerous operations on our datasets using its tools and features. In many instances, you may need to ...

In this tutorial, I am going to show you 4 quick tricks to find the second largest value with criteria in Excel. You can use these methods even in large ...

For different circumstances, you may need to find the minimum value in Excel, you can do that easily. Today we are going to show you how to find the minimum ...

For different purposes, you may need to find the number of occurrences between two dates. You can fetch the count value easily once you have known the ...

In real-life scenarios, you may deal with different sum operations in Excel, like the sum with multiple criteria, the sum entire column, the sum of every other ...

When working with large datasets, sometimes it might occur to us that we need to sum specific cells of a column according to some specific criteria. You can ...

We often need to sum data that fulfill particular criteria. The summation may include fulfilling multiple criteria in different columns. Excel provides the ...

While dealing with a large dataset, adding many rows to your worksheet is necessary. But at the same time, you may need to hide some rows to give the worksheet ...

In this tutorial, I am going to show you 8 quick tricks to count cells with text in excel. You can use these methods even in large datasets to find out the ...

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

Consider a sample dataset where you want to calculate the grade or score average for students. Method 1 - Using Number Formatting in Excel to Round ...

This tutorial will show you how to split a cell by delimiter with the help of a formula in Excel. A delimiter is a character that separates chunks of data ...