-
Converting countif to frequency
Hy everyone,
I have a bit of a problem with my workook. To make some equations work, I would need to count specific values based on the value of the cell next to it. Since there is a lot of data countif doesnt work so good. to speed up the process, I would like to use frequncy instead.
A B
1 nausea treatment A
2 headache treatment B
3 nausea treatment A
4 nausea treatment C
Now what I need is a function (frequency) that would count the occuraces of nausea when treament A was used.
To use countif: =COUNTIFS(A1:A1000,"nausea",B1:B1000,"treatment A")
To use frequency = ??
Thank you
-
My first thoughts on this would be to use a pivot table; they're fast even with lots of data.
Supply a worksheet/book with this sort of data in to help us. Also how you'd like to see the results.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
-
Sorry for the late response. I will actually scrub the whole thing and try a different approach. Got a few ideas that might work, but need a lot of time to do it.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules