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 ?
