Consulting

Results 1 to 2 of 2

Thread: Finding a non-unique value and take max in another column

  1. #1

    Finding a non-unique value and take max in another column

    Hi.
    I hope you can help me with an issue I can't figure out to program in VBA.
    Untitled.png


    My problem is that I need to take the maximum revenue from rows that have the same value(ID)- the remaining revenues should else be 0. My dataset is a lot bigger then the example, but the result should look like this:
    slut.png
    I hope it makes sense, and that you can help me!
    BR
    /Felix

  2. #2
    Knowledge Base Approver VBAX Guru
    Joined
    Apr 2012
    Posts
    4,717
    Why do you expect us to rebuild your file ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •