If I have a column of order numbers (column A) and a column of product items (column B) and I want to know how many product items each order has how would I do that? I prefer not to use a pivot table for this. Technically I just want to know how many times the same order number appears in column A.