Hi All,

I have the data that needs to be arrange in a particular order. for eg.)

Name Marks Comment
Alpha 70 Good
Alpha 80 Very Good
Beta 85 very good
Beta 75 good
beta 60 Average

from the given data I need to pick up the Name with Max mark & its comments.

This is a sample data But I have 5000 lineitems that need to sorted out.

Can any macro be done for this routine job.

thanks,