+ Reply to Thread
Results 1 to 14 of 14

need to get the Highest number from a count and that Name (A) displayed in a new cell

  1. 07-20-2017, 04:27 AM #1
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    need to get the Highest number from a count and that Name (A) displayed in a new cell

    Any help would be great..
    I have a sample attached I need to get the formula to get the Highest number from Col O and display the name from Col A in a separate Cell.
    TIA
    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-20-2017, 04:31 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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Welcome to the forum! Try this:

    =INDEX(A2:$A$102,MATCH(MAX($O$2:$O$102),$O$2:$O$102,0))
    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-20-2017, 04:46 AM #3
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Awesome response time !!! Thanks a lot Ali G
    Reply With QuoteRegister To Reply
  4. 07-20-2017, 04:50 AM #4
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    You're welcome!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  5. 08-01-2017, 10:04 PM #5
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Sorry for the delay...
    If I wanted to display all of the results that have an equal total number?
    Reply With QuoteRegister To Reply
  6. 08-02-2017, 03:14 AM #6
    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 (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,480

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    How do you want them displayed?
    Reply With QuoteRegister To Reply
  7. 08-02-2017, 03:21 AM #7
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,992

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Try

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


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    Drag down!!
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  8. 08-02-2017, 10:32 AM #8
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    I interpreted a little differently.

    Similar to shukla.ankur281190 array entered in P2.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Then similarly for the scores array enter in Q2.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    These will group all same scores with names in descending score order.
    Dave
    Reply With QuoteRegister To Reply
  9. 08-02-2017, 10:00 PM #9
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Displayed in a separate list start at P1 ?
    Reply With QuoteRegister To Reply
  10. 08-02-2017, 10:04 PM #10
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Yes. I just put it in P2 for asthetics ... to line up with the source table.

    Edit Just remember to change the ROWS($2:2) to ROWS($1:1)
    Reply With QuoteRegister To Reply
  11. 08-02-2017, 10:08 PM #11
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Hi Dave,
    I am sorry, I cannot get that to work at all...
    Is there something I am missing?
    Reply With QuoteRegister To Reply
  12. 08-02-2017, 10:12 PM #12
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    The formulas need to be array entered.

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 08-02-2017, 10:30 PM #13
    Codgerz
    Codgerz is offline
    Registered User
    Join Date
    07-20-2017
    Location
    Australia
    MS-Off Ver
    10
    Posts
    6

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Cheers mate, worked like a charm once I understood the array part!!
    Cant make allowances for my slow brain... haha
    Reply With QuoteRegister To Reply
  14. 08-02-2017, 10:40 PM #14
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: need to get the Highest number from a count and that Name (A) displayed in a new cell

    Good deal.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  2. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2005, 01:05 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