srbball790

Hi thanks for your time.

I have many lines of data such as:
2.0 5
2.0 6
3 10
3 20
20 3
20 2
20 11

I will have 3 cells that will give the maximum in the 3 ranges (e.g., 2.0,3,20. The amount of 2s, 3s, & 20s (or other numbers being used) vary. Is there an excel formula or rather a macro that can do this for me? I am not that great at programming so I am sorry if I cause an inconvenience.

Thanks for your help! :-)