M
mark
Hi!
I am wondering if anyone could help with one problem. I am trying to
sort and calculate the frequencies from a long list. I know how to use
the FREQUENCY formula but if I have like to lists. for instance
A1:A10 and B1:B10
8 3100
7 1500
3 2000
4 1000
10 9000
1 8000
30 9000
20 5000
11 2000
22 1000
What I want is that I could get frequencies of these numbers, for
instance the frequency that the first is true with between 0<a<5 and
then 0<b<3000. So there is (A3;B3) are (3;2000) and they are counted
like one hit.
then 4 is also between 0 and 5, and the determined number is 1000, so
another hit. Then
A6 has a number of 1, but the B6 is 8000 which is outside the 0<b<3000
so we can't take it into account.
so we have for 0<a<5 and 0<b<3000 is 2
5<a<10 and 3000<b<6000 is 1
etc.
Just wondering if anyone would help me with this issue. I have a long
list of these and would help me a great deal if I could combine these
two by using advanced use of FREQUENCY formula. or maybe some
combination of FREQUENCY, COUNTIF AND OR formulas? Thank you so much
in advance!
Best regards,
Mark
I am wondering if anyone could help with one problem. I am trying to
sort and calculate the frequencies from a long list. I know how to use
the FREQUENCY formula but if I have like to lists. for instance
A1:A10 and B1:B10
8 3100
7 1500
3 2000
4 1000
10 9000
1 8000
30 9000
20 5000
11 2000
22 1000
What I want is that I could get frequencies of these numbers, for
instance the frequency that the first is true with between 0<a<5 and
then 0<b<3000. So there is (A3;B3) are (3;2000) and they are counted
like one hit.
then 4 is also between 0 and 5, and the determined number is 1000, so
another hit. Then
A6 has a number of 1, but the B6 is 8000 which is outside the 0<b<3000
so we can't take it into account.
so we have for 0<a<5 and 0<b<3000 is 2
5<a<10 and 3000<b<6000 is 1
etc.
Just wondering if anyone would help me with this issue. I have a long
list of these and would help me a great deal if I could combine these
two by using advanced use of FREQUENCY formula. or maybe some
combination of FREQUENCY, COUNTIF AND OR formulas? Thank you so much
in advance!
Best regards,
Mark