In this article, we will learn Find Occurrence of Text in Excel. Scenario: To find the first occurrence of a character in Excel we use the F...
Question asked by user @ Excel forum :- Conditional Formatting based on dates I have been searching but i cant solve my issue, I want to condit...
Microsoft Excel is having so many unbelievable capabilities that are not instantly perceived. In which Conditional Formatting is one of the optio...
When we open new Excel workbook has only one sheet by default. In this article we will learn about how we can change the default number of sheets in a...
In this article, we will learn how to use SUMIF function in VBA with multiple criteria in Excel using VBA code. To get the output, we will use a co...
In today’s world everyone loves splash screen appearing on the screen for few seconds as they open any file. Most of the people are unaware about sp...
In this article you will learn how to create dynamic drop down list; after the selection from first list the second drop down list will be dynamically...
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.