Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Frequency ( ) Epinn New Users to Excel 2 September 21st 06 08:42 AM
histograms - frequency and relative frequency? confusedstudent Excel Discussion (Misc queries) 2 February 8th 06 08:20 AM
3-D Frequency Chart in VBA [email protected] Charts and Charting in Excel 0 July 5th 05 05:19 PM
Combine FREQUENCY and SUM of Associated Values MichaelC Excel Worksheet Functions 3 July 3rd 05 01:54 AM
Frequency for Histograms in Excel Jim Charts and Charting in Excel 7 February 24th 05 07:33 PM


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"