In this article, we will learn how to sum if values only if text ends with a certain characters. Sometimes we need to find the sum of values with m...
In this article, I will explain how you can format a cell if cell/s are blank in other columns. To understand this conditional formatting in excel let...
The SORT function is introduced in Excel 365 online. It is an dynamic array function that sort the given array into ascending and descending orders. T...
The SORTBY Function of Excel can return a sorted array by another independent array. You can add levels of sorting. In other words you can sort arra...
To highlight dates that are coming in the next N days from today, we will use conditional formatting of Excel. The generic formula in conditiona...
In data analysis and MIS reporting, we often get the need to highlight the top and bottom values. This helps us to easily identify focus areas. In t...
Well, we know that the domain name always comes after the @ sign in any email id. To extract domain name from email address we can use this fact. So t...
The VLOOKUP function works fine with wildcard characters. We can use this to extract the first text value from a given list in excel. Here is the gene...
In most of the industries, the sales and other values are summarised on monthly basis. Some times it is also summarized on standard 30 day interval....
The Excel REPLACE function is used to replace a certain length of text from a given string. We define the starting position, the number of characters...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
