getting max value using vba based on multiple criteria

[ratm698]

Hello, need help with the attached excel file. I need a script to run and look for maximum values under Discount% of a particular Customer but only under Category 'a' and 'b'. The result should then be displayed under Result Column on row of category 'a'...Thanx in advance.....

[Mumps1]

Format column E as percentage and try this macro:

Please Login or Register  to view this content.

[jindon]

E2:

=IF(COUNTIF(A$2:A2,A2)=1,MAX(IF(($A$2:$A$10=A2)*(($C$2:$C$10="a")+($C$2:$C$10="b")),$D$2:$D$10)),"")

confirm with Ctrl + Shift + Enter (array formula entry) and copy down.


VBA

Please Login or Register  to view this content.

[ratm698]

I tried to incorporate it into my workbook but did not work. Sorry, I misrepresented my actual worksheet in sample file. So, uploading the sample file again with desired result.

[jindon]

Please Login or Register  to view this content.