Frequency
 

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

Frequency
 

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(pa rt,part,0)))))

Whe 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

"Luis Rodriguez" <Luis wrote in message
...
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

Frequency
 

Thanks a ton, Buff. This is great!

Luis

"Biff" wrote:

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(pa rt,part,0)))))

Whe 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

"Luis Rodriguez" <Luis wrote in message
...
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

Frequency
 

You're welcome. Thanks for the feedback!

Biff

"Luis Rodriguez" wrote in message
...
Thanks a ton, Buff. This is great!

Luis

"Biff" wrote:

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(pa rt,part,0)))))

Whe 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

"Luis Rodriguez" <Luis wrote in
message
...
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