Most frequent

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table which has one field as a breakdown description eg electrical, mechanical etc. and in the other field it displays how many occurance of each description has occured. I need in a separate cell to display the most frequent breakdown type.
E
Description Number of occurances
Electrical 15
Mechanical 12
Human

Most frequent breakdown Electrical

The table is too big to keep looking trough manually so I need excel to tell me that electrical is the most frequent breakdown

Thanks
L. Jones
 
L. Jones

Here's one way assuming description in A2:A500 and
number of occurences in B2:B500:

=INDEX(A2:A500, MATCH(MAX(B2:B500),B2:B500,0))

In case of duplicate numbers, only the first found will count.


--
Best Regards
Leo Heuser

Followup to newsgroup only please.

L. Jones said:
I have a table which has one field as a breakdown description eg
Click to expand...
electrical, mechanical etc. and in the other field it displays how many
occurance of each description has occured. I need in a separate cell to
display the most frequent breakdown type.
Eg
Description Number of occurances
Electrical 15
Mechanical 12
Human 3

Most frequent breakdown Electrical

The table is too big to keep looking trough manually so I need excel to
Click to expand...
tell me that electrical is the most frequent breakdown.
 
With description in col. A and no. of occurrances in col.
B:

=INDEX(A1:A3,MATCH(MAX(B1:B3),B1:B3,0))

Change the range sizes to suit.

HTH
Jason
Atlanta, GA
-----Original Message-----
I have a table which has one field as a breakdown
Click to expand...
description eg electrical, mechanical etc. and in the
other field it displays how many occurance of each
description has occured. I need in a separate cell to
display the most frequent breakdown type.
Eg
Description Number of occurances
Electrical 15
Mechanical 12
Human 3

Most frequent breakdown Electrical

The table is too big to keep looking trough manually so
Click to expand...
I need excel to tell me that electrical is the most
frequent breakdown.
 
See
http://tinyurl.com/34w7d

L. Jones said:
I have a table which has one field as a breakdown description eg
Click to expand...
electrical, mechanical etc. and in the other field it displays how many
occurance of each description has occured. I need in a separate cell to
display the most frequent breakdown type.
Eg
Description Number of occurances
Electrical 15
Mechanical 12
Human 3

Most frequent breakdown Electrical

The table is too big to keep looking trough manually so I need excel to
Click to expand...
tell me that electrical is the most frequent breakdown.
 
Back
Top