LinkBack URL
About LinkBacks
Hi,
I have data structured like below, but with thousands of rows, and would like to find percentages of females (from column B) in each group (column A).
Any ideas on how to go about this?
Col A Col B
1 M
1 F
1 F
2 M
2 M
2 M
3 F
4 M
4 M
4 M
thanks!
Hi,
I have data structured like below, but with thousands of rows, and would like to find percentages of females (from column B) in each group (column A).
Any ideas on how to go about this?
Col A Col B
1 M
1 F
1 F
2 M
2 M
2 M
3 F
4 M
4 M
4 M
thanks!
Last edited by zuwanda; 02-07-2012 at 10:52 PM.
I am not sure if I understand correctly, but how about this?
=COUNTIF(B:B,"m")/COUNTA(B:B)
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
JapanDave, I don't think I explained myself well, but have it figured out now. Thanks for all the helpful links, and I'll try to be more clear in future posts!
Give a try:
Untitled.jpg
Quang PT
Thanks a lot bebo, that worked. Great to learn about COUNTIFS!
best
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks