Hi all - How do I use Excel to give me the number of rows containing a certain item, for all rows?
See 2 tiny examples attached ... that should explain everything! I want excel to tell me how many Cars, how many Boats, and how many Trucks I have. The file is already sorted on that field, and formatting and location of the result is not important ... I just need the numbers. (The actual spreadsheets have 20,000+ records in them)