Results 1 to 20 of 20

Finding maximum of column totals by dates

Threaded View

  1. #1
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,136

    Finding maximum of column totals by dates

    Dear All

    I would like to find the maximum of column totals by dates:

    In the example below, for 01/08/21
    Count1 = 1 + 0 + 1 = 2
    Count2 = 1 + 1 + 1 = 3
    Count3 = 1 + 0 + 0 = 1
    Count4 = 0 + 0 + 0 = 0
    MaxCount = MAX(2,3,1,0) = 3

    Thank you!

    Maximum of sum of column totals by dates.png
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Finding column header and value of first column based on maximum value of range
    By dpalmer76 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-05-2021, 10:04 AM
  2. [SOLVED] Finding Maximum from Cell to Last Entry in each column : Using For..Next
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2018, 02:08 PM
  3. [SOLVED] finding a maximum value from column which has grouped data
    By learnings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2017, 03:26 AM
  4. Finding maximum between dates with a suffixed number
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-02-2016, 03:13 PM
  5. Finding an adjacent value after finding a maximum value on another column
    By VanCricken in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-10-2016, 11:58 AM
  6. Replies: 7
    Last Post: 10-07-2015, 03:01 PM
  7. finding the minimum value in a column that comes after the maximum value
    By rantarctica in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2008, 04:42 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1