I've got a 300 row spreadsheet and I want to calculate the Max and Min
values in Column A based on an integer in Column B.


In the example below I'd like to be able to report Max(11) is 230; Min(11)
is 211; Max(10) is 200; Max(10) is 195.

Columns A and B will always be integers in descending order.

Can SKS help out

Tx

Rob


230 11
226 11
220 11
220 11
211 11
200 10
198 10
196 10
195 10