In this article, you will learn how to show output with matching criteria using conditional formatting. Q: I have a record set from column A to C (...
In this article we will show you how to create an Invoice template using MS Excel by using simple functions. An invoice is a little piece of paper th...
In this article, we will learn How to Extract First, Middle and Last Name from One Cell Into Separate Cells In Excel. Scenario: Splitt...
In this article, we’ll learn the difference between currency and accounting in Microsoft Excel. Though both are very similar to each other but still...
Let’s learn how to compare two strings in Excel. To compare two strings we can use comparison operator “=”. It will work fine until you want to ...
In this article, we will learn about how to Link references with another workbook in Excel. Why do we need to access another workbook? Somet...
In this article, you will learn how to highlight the most recent date in the range. We will use Conditional formatting option along with MAX funct...
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.
