Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency ( ) | New Users to Excel | |||
histograms - frequency and relative frequency? | Excel Discussion (Misc queries) | |||
3-D Frequency Chart in VBA | Charts and Charting in Excel | |||
Combine FREQUENCY and SUM of Associated Values | Excel Worksheet Functions | |||
Frequency for Histograms in Excel | Charts and Charting in Excel |