For the past week or so I've been compiling a list of part numbers for my boss for a number of modules that need to be built for a project we have. However, now that we have the part numbers, we need to tally them up so we know the total number of each part to order. There are several hundred parts listed, many of which are standard parts that repeat themselves throughout the list. I could use a COUNTIF function with the text string of each individual P/N (since each P/N is unique to that part), but doing this for several hundred parts, even if many are repeated, would probably take hours. Is there a simple way for Excel to simply take a column of data and automatically count the instances of each entry? The person who posts a good solution wins +100 internets, and my hearfelt thanks.
Bookmarks