I need to summarize a data set by listing an Order #, all of the unique Serial #'s associated with that Order # (Order #'s can be repeated), and the revenue, costs, and units associated with that unique serial number.
The attached file better simply demonstrates the issue I'm trying to solve.
I'd imagine this can be solved with some combination of UNIQUE, FILTER, and XLOOKUP, but any help would be great.
Thanks!
Bookmarks