Merge name against unique group and get max value for group

Dear All,

For merging value against group I have posted question in forum and MickG has given me vba code as solution. Please refere link

http://www.excelforum.com/excel-gene...que-value.html

Now I have value in column "C" and "D". I need vba code to get maximum value for each group.

Kindly refer attached file.

Regards,

PN

VBA

Please Login or Register  to view this content.

Dear Jindon and oeldere,

Thanks for your kind reply. oeldere I am not used to with Pivot table.
Jindon your solution is perfectly working. Thank you very much .

Regards,

PN

Dear jindon,

I need to run this from any worksheet in work book.

Suppose I have this data in WS3 workbook.

What would be modification I need to do so that I can run this macros from any worksheet in the workbook.

Regards,
PN

Please Login or Register  to view this content.

yes man This is working. Thank you for your kind help. I tried but failed to modify last two lines.

End With
.[h1].Resize(i, UBound(a, 2)).Value = a
End With

Now if value in Column "C" and "D" have formula how could I get the result.

Regards,

PN

I don't understand what you are asking.

Post a workbook with before/after.

Sorry for trouble. Actually I have set calculation mode to manual resulting in error. Mistake on my part.

Regards,

PN

Again I made mistake in represent the problem.

I need for each group i.e Column "A" max value from Column "C" and Column "D". File attached herewith.


Regards,

PN

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hey now I got the result. You people are worth the word "GURU".
I thank you for your guidance and Patience.

Regards,
PN