LinkBack URL
About LinkBacks
Is there a way that excel will count how many cells in a column have data in them, in this case peoples names?
Much obliged.
Is there a way that excel will count how many cells in a column have data in them, in this case peoples names?
Much obliged.
Last edited by Marvo; 12-07-2012 at 03:57 AM.
Counta function. Look here
http://www.techonthenet.com/excel/formulas/counta.php
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
How about
Formula:
Please Login or Register to view this content.
Change the column reference A:A to your desired Column.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
That's brilliant. Perfect. Much obliged.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks