PDA

View Full Version : Finding a non-unique value and take max in another column



WhiteCollar
12-07-2015, 02:27 AM
Hi.
I hope you can help me with an issue I can't figure out to program in VBA.
14906


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:
14907
I hope it makes sense, and that you can help me! :)
BR
/Felix

snb
12-07-2015, 03:01 AM
Why do you expect us to rebuild your file ?