max value of each group of values

 

 

dear sir,

how to find max values of each group value,

ColumnA        ColumnB

100                0.22

100                0.35

100               0.22

100               0.15

100              0.50

50                0.11

50               0.35

50               0.22

50               0.55

50              0.50

10                0.22

10                0.45

10               0.22

10              0.15

10              0.88

 

By: Saleem Puthiya Purayil

Leave a Reply

Your email address will not be published. Required fields are marked *