ExcelBanter - How can i do a frequency distribution by machine automatically?

Hello:

Why do you need an index? The following would work:

Assume that "Machine" is in column A and Col B contains "Mac 1"; col C "Mac 2" etc

=IF(A2=C$1,B2,0)

This will put the values in columns. Use the Histogram wizard on the data analysis menu
and it will create the histogram (be sure that the bin values include zero). Ignore the
zero bin when you are done and you have the histogram you wanted.

Alternative

Why not just sort the values on column A and then create the histograms(or frequency)
by selecting the appropriate groups of cells.

Pieter Vandenberg

-----------------------------------------------
Anti-spam
Please do not reply to this message's address.
If you wish to contact me use the above address.
Thank you.
------------------------------------------------

Steve wrote:
: 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 ?