+ Reply to Thread
Results 1 to 6 of 6

Macro for Maximum of different sums

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2010
    Posts
    20

    Macro for Maximum of different sums

    Help, please...
    I need a macro who will determine the maximum of different sums of series.
    A series means white cells with values. If a white cell with value it's followed by a white cell without value, the series it's end.
    if the white cell it's followed by a different color cell, with no value, it's still a series if the next white cells contain a value.
    a attached an exemple, i hope you can help me.
    thank you very much, have a nice spring!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-12-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Macro for Maximum of different sums

    there's no hope for my problem?..

  3. #3
    Registered User
    Join Date
    06-12-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Macro for Maximum of different sums

    hello
    i try to simplify the initial post:i need a macro who must to determine maximum of diferent sums from an array of numbers...
    for instance: 1, 1, 1, 0, 0, 1, 0, 1, 1, 0, 1, 1, 1, 1, 1
    the maximum must to be 5
    anyone please??

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Macro for Maximum of different sums

    Please find the attached workbook. Click the button to find the sum as per your criteria.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  5. #5
    Registered User
    Join Date
    06-12-2012
    Location
    bucharest
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Macro for Maximum of different sums

    Thank you sktneer,
    works perfect!!

  6. #6
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Macro for Maximum of different sums

    You're welcome. Glad I was able to help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I need a macro to do sums in a worksheet
    By KaiserD2 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-30-2014, 11:51 AM
  2. [SOLVED] VBA/Macro for a lot of Sums
    By mahatze in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-27-2014, 11:22 AM
  3. [SOLVED] Macro that sums all categories
    By djasper6 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 01:26 AM
  4. Macro which sums up equally colored cells
    By Marina86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2013, 08:40 PM
  5. Macro to insert line and sums
    By room7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2011, 09:45 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