+ Reply to Thread
Results 1 to 4 of 4

Extract Unique from on column and corresponded MAX value from other column !

  1. #1
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Excel 2016
    Posts
    584

    Extract Unique from on column and corresponded MAX value from other column !

    Data is in B:C, B text data, C numerical data
    I want in E:F, in E Unique from B (I have it already) and F I want corresponded MAX value from B
    I have in F how should be
    Answer please at F2
    Attached Files Attached Files

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,168

    Re: Extract Unique from on column and corresponded MAX value from other column !

    In F2:
    =AGGREGATE(14,6,$C$2:$C$19/($B$2:$B$19=E2),1)

    Copy down.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Contributor
    Join Date
    05-20-2016
    Location
    Detroit
    MS-Off Ver
    Excel 2016
    Posts
    584

    Re: Extract Unique from on column and corresponded MAX value from other column !

    Thank you so much, simple answer, .....I need to learn Excel...

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,168

    Re: Extract Unique from on column and corresponded MAX value from other column !

    You are welcome and thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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