Sometimes data in a worksheet is too complicated or crammed that we face difficulties to find out desired data. Retrieving data from a dataset sometimes turns ...
Md. Abdullah Al Murad
Sometimes we need to compare two lists in Excel for various purposes. In Excel, the list can be presented in two ways. It can be column-wise or row-wise. MS ...
Sometimes we may need to get a summation based on different criteria. For this purpose, Excel provides a function called SUMIFS. This is the updated version of ...
When we need to compare data in two or more ranges and calculate data with multiple criteria or conditions, Excel provides a function named SUMPRODUCT. This ...
In various calculations, we may need to calculate maximum values from any given dataset. Excel provides its built-in function which is the MAX function which ...
When we compare just two cells manually, it is not difficult. But it's never easy to compare hundreds and thousands of text strings. Fortunately, MS Excel ...
For conditional sum in Excel, SUMIF is one of the most used functions provided by MS Excel. It is a combination of SUM and IF (SUM+IF), which means it checks a ...
For project planning or time management, we need to make a routine or schedule. Making time schedules, MS Excel provides different ways to add months to date. ...
Sometimes we need to add values based on one or many criteria. Excel makes this easy by providing functions such as SUMIFS. Where SUMIF is for adding numbers ...
Year-to-Date in short YTD is used to start the first day of the current calendar year up to the current date. It is mostly used in analyzing a business or ...
Sometimes we may need to work with multiple ranges on the same criteria in terms of searching, counting, or sorting. In this way, Microsoft Excel helps us by ...
In MS Excel there are several functions purposed for counting different kinds of cells, such as blanks or non-blanks, with a number, date, or text values, ...
We get numbers as output in most operations in Excel. But if those numbers have decimal digits too how then this could cause irritation. For this, we need to ...
Rounding is necessary when we deal with numbers. In Excel, we can easily round numbers to any specific value using different functions. In this article, I will ...
Microsoft Excel is a ubiquitous tool for organizing and analyzing data. Oftentimes, we may need to separate numbers in Excel, therefore, knowing a couple of ...
