Unique, Xlookup, Filter Help Needed

[jk2391]

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!

[Fluff13]

How about

Please Login or Register  to view this content.

[jk2391]

Way simpler than I would've thought.

Thanks!

[Fluff13]

Glad to help & thanks for the feedback.