Counting Unique Values In Excel – 5 Effective Ways

Let’s consider we have a long list of duplicate values in a range and our objective is to count only the unique occurrences of each value.Though this can be a very common requirement in many scenarios but excel doesn’t have any single formula that can directly help us to count unique values in excel inside a range.In today’s post, we will see 5 … [Read more...]

Getting Familiar with VB Editor (VBE) : VBA Basics 002

Now, after having learned what Excel VBA is, let’s move a bit further and see what is VB Editor.VB Editor (or more commonly known as VBE) is the tool used to create, modify and maintain Visual Basic for Applications (VBA) procedures and modules in Excel.NOTE: Many people also refer VBE as Excel IDE, IDE stands for integrated development … [Read more...]

What is Excel VBA? : Excel VBA Basics 001

Visual Basic for Applications (VBA) in Excel, is a powerful and sophisticated built-in programming language that allows you to write your own functions or commands in an Excel spreadsheet.These custom functions or commands, can help to ease your tasks and thus by using Excel VBA you can do almost any imaginable thing in Excel.Now, before we … [Read more...]