Frequency

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

Guest

How would I determine the frequency of a text cell, based on a specific
criteria, and then have it display the most frequent text. In other words,
let say you have the following:

Car Make Model Parts
Honda Accord Fan
Chevy Blazer Hose
Honda Civic Glass
Honda Accord Belts
Honda Accord Fan
Chevy Blazer Hose
Chevy Impala Hose
Honda Accord Fan


How would I be able to determine which part is most frequently used, based
on the spefic "Make" and "Model" criteria and then display the most needed
part.
In other words:

Car Make Model Most Used Part
Honda Accord FAN
Chevy Blazer HOSE


Any asistance would be greatly appreciated
 
This works as long as there is a "mode" (more than 1 matching part):

Entered as an array using the key comination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(part,MODE(IF(make=A15,IF(model=B15,MATCH(part,part,0)))))

Where: A15 = Honda, B15 = Accord, returns: fan.

Based on your sample data the formula will reurn #N/A if you wanted Honda
Civic because there's only one instance of Honda Civic and one instance of
glass for Honda Civic. In other words, there's not a "mode" for those
criteria.

Biff
 
Thanks a ton, Buff. This is great!

Luis

Biff said:
This works as long as there is a "mode" (more than 1 matching part):

Entered as an array using the key comination of CTRL,SHIFT,ENTER (not just
ENTER):

=INDEX(part,MODE(IF(make=A15,IF(model=B15,MATCH(part,part,0)))))

Where: A15 = Honda, B15 = Accord, returns: fan.

Based on your sample data the formula will reurn #N/A if you wanted Honda
Civic because there's only one instance of Honda Civic and one instance of
glass for Honda Civic. In other words, there's not a "mode" for those
criteria.

Biff
Click to expand...
 
Back
Top