Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i do a frequency distribution by machine automatically
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Median for frequency distribution | Excel Worksheet Functions | |||
Frequency distribution | Excel Worksheet Functions | |||
how do I construct frequency distribution chart | Charts and Charting in Excel | |||
Frequency distribution | Excel Discussion (Misc queries) | |||
Sorting - Frequency distribution. | Excel Discussion (Misc queries) |