Hello experts.
I need to filter rows from a purchases table, and only show one for every customer, the exact one for their latest purchase. I later need to include these rows on a tabular form so I can color code them by date using conditional formatting.
How do I do this? How do I design a query that selects all the rows that meet these two criteria:
1. Customer name (no duplicates)
2. Purchase date (latest purchase from this customer)
Any pointers are greatly appreciated