In this post, I will show you the trick to make the function SUMPRODUCTIF. We have the SUMPRODUCT function in excel. But how to make a SUMPRODUCT function that follows criteria like SUMIF? Here I have made an example. Here’s …
Lesson#132: How to make the function SUMPRODUCTIF Read more »
In this post, I will show you a simple trick by which you can find out complete blank rows in the Excel datasheet. I have made an arbitrary sheet to describe. I have to find out only completely blank rows …
Lesson#131: Find out complete blank rows in the Excel datasheet Read more »
Here I am having an example to show you the Paste Special with skip blanks in Excel. Serials are incomplete in both columns. In column A even numbers are absent and in column B odd numbers are absent. If you …
Lesson#130: Paste Special with skip blanks in Excel Read more »
Hello friend! I am going to share some information about Formula Auditing in Microsoft Excel. In the Formula ribbon, you can get a group of features named Formula Auditing. It includes Trace Precedents Trace Dependents Remove Arrows Show Formulas Error …
Lesson#129: An overview of Formula Auditing in Excel Read more »
Here I will show how to make auto arranged serial no when you filter a column. This post will be very useful to many excel users like me. Suppose you are using a data sheet and you need to filter …
Lesson#128: Formula to make serial no auto arranged when filtered Read more »
An easy and simple trick to make a color picker will be shown here. Here I have made a color palette by coloring different cells with different colors. This palette allows us to pick different types of colors by selecting …
Lesson#127: Trick to make a color picker with VBA Read more »
Here I will show you how to make a simple color tester with VBA. This color tester is having only one big button. It will take input from the user for the value of Red, Green, and Blue. Then it …
Lesson#126: Making a simple color tester with VBA Read more »
Hello, we are back again with a very basic VBA learning topic. How to use a function with VBA. Here I am having an array with some random numeric values in the range A1:A10. I want to make SUM, AVERAGE, …
Another step towards learning VBA. In this post, we will learn to format text in excel with VBA. In the previous post, I discussed changing the cell background color and color codes. Lesson#123: How to change cell color with VBA …
Lesson#124: How to format text in excel with VBA Read more »
