How to count distinct values in a column, categorized by values in another column.

Hi,

Just had this problem, and I made up an example to explain it. Please download the attached Excel file.

From the example, Table 1 is to store the raw data. Say we have different car models, A to L. The 2nd column gives the makes of the models. (Here the data type could be numeric.) The 3rd column shows the types of the models.

Table 2 will do the calculation and show the results. Column 2 should show how many different types each make contains. For instance, there should be only 1 type for Jeep, which is the SUV.

Thanks for the help!

Joe