« ALT + F + P (Print Properties) | What is the difference between a Link and an Object? » |
Hi there,
I have a tiny formula which does the important task in Excel. Do you know how to count colored cells? Then why are you waiting for try, how to count blank cells now?
We have a raw data like this:
...
Are you thinking we need to use multi functions to complete this task?
Nothing !
Nothing for Sure !!!
How do you do?
It's very simple and easy because we have an inbuilt function by Microsoft which is COUNTBLANK.
Magic works!!!
DO YOU USE COUNTBLANK?
You can share your views and suggestions on this post using below our space in comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to support me, REGISTER here for free. Its absolutely free.
Registered users will receive Monthly Newsletters, Weekly newspaper, FORMULAS CHEAT SHEET & CHEAT VOICE, ALL Latest Updates from "exceltoxl".
SOME IMPORTANT LINKS:
Extract User Name and Domain Name
Extract 2nd, 3rd, 4th & 5th instance using VLOOKUP
Learn Formulas (Using kid's story)
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments