how to find max values of each group value

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
 i want find maximum value of each group, like max value from columnB where columnA is 100, and max value from columnB where columnA is 50  like

By: Saleem Puthiya Purayil

Leave a Reply

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