Gentlemen and Ladies,
Thank you for all your help on my previous problem. Here is my next issue.
I have a 2 columns of information 49 rows deep, giving me a total of 98 cells. I need a formula that will show me a % of those 98 cells that have information in them. IE if all of the cells in column A are filled, 50%, or if 12 cells in both columns are filled, 25%, etc.
Once again thank you for all your help.
Last edited by listmaker1984; 02-10-2010 at 07:59 PM.
Maybe this in a cell formatted as percentage:
=COUNTA(A1:B49) / 98
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks