I've got a large excel sheet with duplicate values in Column A and dollar values in column B.

I need to delete the duplicate values in column A, so that only the minimum dollar value is left in Column B.

Example:


A B

1 5
1 6
2 6
2 7
3 1
3 6
3 5
4 2
4 3

The answers should read:

1 - 5
2 - 6
3 - 1
4 - 2

Please help!

Thanks