+ Reply to Thread
Results 1 to 5 of 5

getting the highest number from a set of cells

  1. 06-04-2018, 05:41 PM #1
    mvgajr
    mvgajr is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    19

    getting the highest number from a set of cells

    If I have 4 cells with different numbers ( a1,a2,a3,a4) and I want the highest number on any of the cells to populate on b1 how can I do it
    Reply With QuoteRegister To Reply
  2. 06-04-2018, 06:07 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: getting the highest number from a set of cells

    Do you mean that 1 cell contains the text a1, another contains a2 etc?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-04-2018, 09:28 PM #3
    jtakw
    jtakw is offline
    Valued Forum Contributor jtakw's Avatar
    Join Date
    05-05-2018
    Location
    CA, USA
    MS-Off Ver
    2016
    Posts
    668

    Re: getting the highest number from a set of cells

    Hi,

    May be this, if not, you need to answer FDibbins' question:

    =MAX(A1:A4)
    Reply With QuoteRegister To Reply
  4. 06-05-2018, 01:34 PM #4
    mvgajr
    mvgajr is offline
    Registered User
    Join Date
    05-17-2012
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    19

    Re: getting the highest number from a set of cells

    It worked perfect. THANK You
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-05-2018, 04:06 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: getting the highest number from a set of cells

    Im happy you got your answer, but for future reference, if you have an excel question, upload an excel file, not a word document
    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. Want to multiply a range of cells by one number but I want to exclude the highest number
    By jameshealy19 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2015, 12:30 PM
  2. need macro to give highest number and one for lowest number in previous 5 cells, urgent
    By Bonaney in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 10:41 AM
  3. VBA code to find highest and 2nd highest number based in criteria
    By Michael007 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-25-2011, 08:38 AM
  4. Formula to enter highest number from a range of cells
    By batjl9 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-26-2011, 04:32 PM
  5. Orgainzing cells by highest number(Solved)
    By loJic in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 01-12-2010, 03:44 AM
  6. Finding highest number in a range of cells
    By marcusr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2007, 08:42 AM
  7. [SOLVED] 2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates
    By John in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-10-2006, 11:40 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