+ Reply to Thread
Results 1 to 4 of 4

Unique, Xlookup, Filter Help Needed

  1. #1
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    46

    Question Unique, Xlookup, Filter Help Needed

    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!
    Attached Files Attached Files
    Last edited by jk2391; 06-23-2022 at 02:44 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,033

    Re: Unique, Xlookup, Filter Help Needed

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    04-03-2020
    Location
    NYC
    MS-Off Ver
    365 Pro Plus
    Posts
    46

    Re: Unique, Xlookup, Filter Help Needed

    Way simpler than I would've thought.

    Thanks!

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,033

    Re: Unique, Xlookup, Filter Help Needed

    Glad to help & thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Index/Match, Xlookup, Concatenate - Help Needed
    By jk2391 in forum Excel General
    Replies: 3
    Last Post: 06-23-2022, 01:24 PM
  2. Replies: 2
    Last Post: 03-04-2022, 01:18 AM
  3. Replies: 7
    Last Post: 12-10-2021, 02:17 PM
  4. Replies: 5
    Last Post: 08-17-2021, 03:06 PM
  5. [SOLVED] Filter by Unique value - correct code to be able to enter range as needed
    By mrsklb09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 08:50 AM
  6. Replies: 5
    Last Post: 12-19-2013, 06:58 AM
  7. Complex Filter/Sorting Help Needed (VBA knowledge needed)
    By dfxryanjr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 01:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1