Get maximum value for unique record in three column

[pnnaik]

Dear All,

I have data from column A to F.

For each unique record Row wise in Column "B". "E" and "F" I want max value in Column "C".

Kindly go through attached file in which I have shown "Data" sheet and "REQUIRED RESULT" sheet. I wish to have solution using VBA. In "DATA" Sheet In "H" to "N" Column I have shown how logic goes.

Regards,

PN

[xladept]

Hi PN,

Try this:

Please Login or Register  to view this content.

[pnnaik]

Dear xladept,

This is perfect. Thanks for kind reply and solution. If you spare few minutes and provide short explanation on this code we
can learn from you "Gurus".

Also Column "H" record ( like Record for X1), I show for expiation, do not required that column.


Regards,
PN

[xladept]

Hi PN,

Thanks for the rep!

Please Login or Register  to view this content.

[pnnaik]

Dear xladept,

Thanks for your kind help.

Regards,
PN

[xladept]

You're welcome!