Results 1 to 6 of 6

Finding maximum value of 3 contiguous cells in a row

Threaded View

  1. 11-14-2018, 11:39 AM #1
    j_Southern
    j_Southern is offline
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Finding maximum value of 3 contiguous cells in a row

    I have a worksheet with 12 columns and many rows.
    I need to find the maximum value of any 3 touching cells in each row. That is the maximum of A+B+C, B+C+D, C+D+E and so on.
    I can achieve this by brute force, but I feel that an elegant solution might well be possible.
    I have attached a sample of one row as an illustration,
    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Finding maximum value in row, and give the column names in which these maximum values are
    By sankoo in forum Excel General
    Replies: 7
    Last Post: 10-07-2015, 03:01 PM
  2. [SOLVED] Finding the First Value from Cells That Are in the Same Row But Are Not Contiguous
    By JFactor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-14-2015, 06:21 PM
  3. Finding maximum value (but exclude blank cells)
    By CL39 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 06:26 PM
  4. [SOLVED] copy and paste from contiguous cells to non-contiguous cells using the = function
    By shameus in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-05-2013, 06:48 PM
  5. Finding the maximum value for each group of cells
    By TF1985 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-27-2012, 11:38 AM
  6. Finding the maximum occurrence of text over non-consecutive cells
    By raehippychick in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2009, 09:04 AM
  7. [SOLVED] Is there a maximum number of non-contiguous columns that can be h.
    By Harold in forum Excel General
    Replies: 6
    Last Post: 03-01-2005, 06:06 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