How can I find out how many different values I have in a data range? I have a spreadsheet of hundreds of bills of material. Each column has a type of component. Most on the components are used in multiple finished goods. How can I find out how many different unique part numbers I have in each column?