excel-formulas
Combine Excel's UNIQUE, LEFT, SEARCH & SORT Functions
What I'm trying to solve 🧩 I had a column of 100 order lines, with each line beginning with the product name, then the order date, then the customer name. My goal was simple: show each product only once. Duplicate products appear throughout those 100 rows, and the product