+ Reply to Thread
Results 1 to 4 of 4

Filtering With Duplicates and Max for Entire Row Output

  1. #1
    Registered User
    Join Date
    01-13-2021
    Location
    Atlanta, GA
    MS-Off Ver
    365
    Posts
    3

    Question Filtering With Duplicates and Max for Entire Row Output

    Hello,

    Hope I explain this well:

    I have tried multiples ways and nothing seems to be working right, even though it seems very easy if my head!

    I need to return an entire row based on criteria in columns A and B. Column A is 1-100. And Column B is random numbers, but there are some duplicates. So I want to return the entire row for each row (and of duplicates), using the highest of Column A for each column B. Is that possible with a function??

    Not to mention have to add this to another already long equation, but will worry about that after.

  2. #2
    Registered User
    Join Date
    01-13-2021
    Location
    Atlanta, GA
    MS-Off Ver
    365
    Posts
    3

    Re: Filtering With Duplicates and Max for Entire Row Output

    Let's say I have this:

    A B C D E
    200 219 2017 M 35
    201 219 2017 M 35
    202 219 2017 M 35
    203 219 2017 M 35
    204 219 2017 M 35
    205 219 2017 M 35
    206 220 2017 M 35
    207 220 2017 M 35
    208 220 2017 M 35
    209 220 2017 M 35
    210 220 2017 M 35
    211 220 2017 M 35

    And it should output: (multiple columns, with highest of column A, given Column B) with forumula
    205 219 2017 M 35
    211 220 2017 M 35

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,461

    Re: Filtering With Duplicates and Max for Entire Row Output

    With output outcome in G1:K9
    H1=B1
    H2:
    Please Login or Register  to view this content.
    Drag H2 down

    G1:
    Please Login or Register  to view this content.
    Drag down

    Copy column G to H, I, J, K
    Attached Files Attached Files
    Quang PT

  4. #4
    Registered User
    Join Date
    01-13-2021
    Location
    Atlanta, GA
    MS-Off Ver
    365
    Posts
    3

    Re: Filtering With Duplicates and Max for Entire Row Output

    Thank you thank you! Looks wayyyy harder than I thought, would never be able to figure that out.

+ 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] Not getting output after filtering
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2016, 11:12 AM
  2. [SOLVED] Filtering Logic - Consider Entire Dataset While Filtering
    By mikegs1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 05:01 PM
  3. Replies: 2
    Last Post: 12-15-2011, 11:49 PM
  4. Problems with filtering and output
    By floep in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-28-2006, 07:49 AM
  5. Problems with filtering and output
    By floep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2006, 10:50 AM
  6. Problems with filtering and output
    By floep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2006, 10:50 AM
  7. [SOLVED] Not filtering entire Database
    By Katie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

Tags for this Thread

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