How can i do a frequency distribution by machine automatically

S

Steve

Machine Speed Mac 1 Mac 2 Mac 3
Mac 1 100 100
Mac 1 200 200
Mac 3 300 300
Mac 1 400 400
Mac 2 500 500
Mac 2 100 100
Mac 2 200 200
Mac 1 500 500
Mac 3 800 800
Mac 3 1100 1100
Mac 3 1400 1400
Mac 3 1700 1700
Mac 3 700 700

How can i do a frequency distribution by machine automatically?
Current i use the index function to group them under the same machine
and follow by a "frequency" function. However, this way it will be
very slow,as the column under Mac 1, Mac 2 and Mac 3 need
to have the function "index". This get more slower when you have 6K
rows of data. How can i do it more efficiently ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i do a frequency distribution by machine automatically? 1
¿How to divide a total into 0
What should formula look like to define date range on SUMIF 2
use more than 7 if condition in a cell 8
If then request 1
LOOKUPS USING 2 SETS OF DATA 5
Another Running Totals Problem 9
Column Heading on each row in pivot table 1

Top