Lesson#137: How to count any character in a text in Excel
Now I will show you to make a formula that can count any specific character or …
Lesson#137: How to count any character in a text in Excel Read more →
Excel Tricks
Lesson#135: MAXIF and MINIF with function IF
In this post, I will show you to make two new functions. These are functions MAXIF …
Lesson#133: Auto numbering formulas in Excel
Hello friends. I am back with another interesting lesson. How to make auto numbering formulas in …
Lesson#131: Find out complete blank rows in the Excel datasheet
In this post, I will show you a simple trick by which you can find out …
Lesson#131: Find out complete blank rows in the Excel datasheet Read more →
Lesson#128: Formula to make serial no auto arranged when filtered
Here I will show how to make auto arranged serial no when you filter a column. …
Lesson#128: Formula to make serial no auto arranged when filtered Read more →
Lesson#127: Trick to make a color picker with VBA
An easy and simple trick to make a color picker will be shown here. Here I …
Lesson#127: Trick to make a color picker with VBA Read more →
Lesson#126: Making a simple color tester with VBA
Here I will show you how to make a simple color tester with VBA. This color …
Lesson#126: Making a simple color tester with VBA Read more →
Lesson#117: How to split up characters of text in excel
Here I will show you a nice trick to split up characters of text in excel. …
Lesson#117: How to split up characters of text in excel Read more →
Lesson#114: How to highlight cells with text or non-text values
We will discuss how to highlight text values or non-text values among an array. In the …
Lesson#114: How to highlight cells with text or non-text values Read more →
Lesson#113: How to highlight cells with errors in it
I will show you how to highlight cells with errors among an array of values. Here …
Lesson#113: How to highlight cells with errors in it Read more →