Hello friends. I am back with another interesting lesson. How to make auto numbering formulas in Excel. I named that formula auto numbering because it helps to create automatic serial numbers. Now I am showing you these formulas with an …
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 will discuss three functions COUNT, COUNTA, and COUNTBLANK, and show their similarity or difference. COUNT COUNTA COUNTBLANK Description The COUNT function counts the number of cells that contain numbers The COUNTA function counts the number of cells that …
Lesson#63: COUNT, COUNTA, COUNTBLANK explaination Read more →
