Results 1 to 10 of 10

How to find the maximum value of the last 6 consecutive days without spaces?

Threaded View

  1. 12-20-2020, 08:59 PM #1
    rayhen
    rayhen is offline
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 365
    Posts
    173

    How to find the maximum value of the last 6 consecutive days without spaces?

    B2:AF2 , the last 6 consecutive days as 18790.425 19480.144 17561.242 22241.642 21808.236 22056.135
    Place the maximum value in cell A2
    B3:AF3 , the last 6 consecutive days as 34507.729 31460.845 30667.831 31876.037 34445.296 34690.466
    Place the maximum value in cell A3
    B4:AF4 , the last 6 consecutive days as 19 3 5 15 12 18
    Place the maximum value in cell A4

    Any help would be appreciated!
    Attached Files Attached Files
    Last edited by rayhen; 12-21-2020 at 03:13 AM.
    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. How to find consecutive 3 days and 2 days particular customer is red
    By sriku in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-13-2020, 02:59 AM
  2. Finding maximum number of consecutive days
    By loumarday in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2019, 11:06 AM
  3. [SOLVED] Maximum cumulative value for the consecutive 3 days of data in 1 year period
    By bennyistanto in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-26-2017, 08:43 AM
  4. How to find the maximum count of consecutive occurances in an excel range
    By manojsinha2006 in forum Excel General
    Replies: 1
    Last Post: 03-20-2015, 03:56 AM
  5. How to find the maximum count of consecutive occurances in an excel range
    By manojsinha2006 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-20-2015, 03:47 AM
  6. Counting Maximum Consecutive Days
    By Delleeb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2013, 03:51 PM
  7. Need to Find the Maximum Sum of Four Consecutive Rows in an Array
    By smotown in forum Excel General
    Replies: 2
    Last Post: 06-26-2012, 03:13 AM

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