How does one cross compare data in Excel? For instance, if you have a table of data (product codes along with the quantity and names for each product for instance), and they need to be classified into 5 product classifications: Lets say you have the product codes for the five classifications—there are several codes that match each of the five classifications, but the codes are not necessarily sequential. You need to take that coding system and apply it to the total list of products, and have Excel spit out a Classification Number for each of the codes (for instance, 1 if the product code fits a code in Classification 1, 2 if the product code fits a code for Classification 2, and so forth). From there, the task is easy—I just sort based on the classification code that Excel produces, and then I can calculate the total number of products in each classification. I just can’t figure out how to cross compare the coding system with the data.