ExcelBanter - Frequency distribution

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Frequency distribution (https://www.excelbanter.com/excel-worksheet-functions/183186-frequency-distribution.html)

Steve

Frequency distribution

Machine Speed Bins
A 10 0
A 20 5
B 30 10
D 40 15
E 50 More
A 60
B 70
F 80

How can I do a frequency distribution by Machine ?

I know how to use "frequency" function but I need to segregate the machine
first . How can I do a better way without segregating the data

Teethless mama

Frequency distribution

=FREQUENCY(IF($A$2:$A$9="A",$B$2:$B$9),C2)

ctrl+shift+enter, not just enter

"steve" wrote:

Machine Speed Bins
A 10 0
A 20 5
B 30 10
D 40 15
E 50 More
A 60
B 70
F 80

How can I do a frequency distribution by Machine ?

I know how to use "frequency" function but I need to segregate the machine
first . How can I do a better way without segregating the data

All times are GMT +1. The time now is 06:19 PM.