Find Occurrence of Text

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...

Conditional Formatting Based on Dates

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...

11 Incredible Excel Conditional Formatting Tricks

 Microsoft Excel is having so many unbelievable capabilities that are not instantly  perceived. In which Conditional Formatting is one of the optio...

Changing the Default Number of Sheets in a New Workbook in Microsoft Excel

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...

SUMIF Function With Multiple Criteria using VBA in Microsoft Excel

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...

How to Create an Excel Splash Screen

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...

How to create dynamic drop down list based on name range in Microsoft Excel

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...

Terms and Conditions of use

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.