Unique Lists in Excel In this tutorial, I’ll walk you through how to create and use unique lists three different ways in Excel. Near the end of the video i will show you how easy and useful they can be when analysing your data. You’ll learn how to take a dataset, remove duplicates, and build a clean list that you can reuse for formulas, summaries, and reporting. Using this unique list, I’ll demonstrate how to: ✔ Use s unique list to calculate total sales volume using SUMIFS ✔ Use another list to Count how many times each item appears using COUNTIF ✔ Copy formulas down your unique list quickly ✔ Use pivot tables to add extra insights with just a few clicks ✔ Build a reliable base structure you can use for more advanced formulas later By the end of this video, you’ll understand how unique lists help keep your spreadsheets organised, accurate, and ready for deeper analysis — whether you're working with sales data, stock lists, customer data, or anything else. If you enjoy practical Excel tips that make your work easier, this video is for you! 👉 Don’t forget to Like, Comment, and Subscribe for more Excel tutorials every week.