6 months agoUse Excel’s UNIQUE function to filter unique items, and COUNTIF to count their occurrencesTechnical Buddy