+ Reply to Thread
Results 1 to 7 of 7

find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

  1. 08-04-2023, 05:13 AM #1
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    How to find the 2nd largest and return the values separated by comma. (using google sheets )


    sample file below.

    thanks
    Attached Files Attached Files
    Last edited by AliGW; 08-04-2023 at 05:16 AM. Reason: Moved to the correct forum section.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  2. 08-04-2023, 05:18 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    Why 2,4,3? Explain. 15 is smaller than 20 ...
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 08-04-2023, 05:20 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    GoogleSheets has FILTER, so try this for no. 2:

    =FILTER(E5:E9,(A5:A9>=F11)*(A5:A9<=F12)*(E5:E9<>""))
    Reply With QuoteRegister To Reply
  4. 08-04-2023, 05:34 AM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    ouch sorry my fault that should be in the 20..
    thanks for the filter formula will try now in google sheet
    Reply With QuoteRegister To Reply
  5. 08-04-2023, 05:49 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    Try this:

    =TEXTJOIN(",",,FILTER(D5:D9,B5:B9>=LARGE(B5:B9,3)))

    or:

    =TEXTJOIN(",",,SORT(FILTER(D5:D9,B5:B9>=LARGE(B5:B9,3)),,FALSE)
    Reply With QuoteRegister To Reply
  6. 08-04-2023, 06:32 AM #6
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    Thank you very much.
    Reply With QuoteRegister To Reply
  7. 08-04-2023, 07:47 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,853

    Re: find 1st,2nd 3rd to 5th largest with duplicates return adjacent cell value

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return Largest Adjacent Value From List With Duplicate Entries
    By jimbex in forum Excel General
    Replies: 10
    Last Post: 08-04-2020, 01:19 PM
  2. [SOLVED] Combining Vlookup with Large to return adjacent cell with duplicates
    By AMille in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-29-2018, 02:28 PM
  3. [SOLVED] Find the three largest values and return the corresponding cell
    By Losguapos1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2016, 03:57 PM
  4. [SOLVED] HELP: Find largest value in a column and return adjacent cell value!
    By KaziProttoy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-07-2015, 08:40 AM
  5. Vlookup formula on duplicates, then find max value in adjacent cell, return adjacent cell
    By comohelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  6. [SOLVED] Find first, second, third largest and return another cell on same row
    By notexcellent in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-15-2013, 09:14 AM
  7. Need Help: Sum a range and return adjacent data tied to largest digit.
    By definajoe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-19-2013, 11:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1