To Find Max value in a One Column

[pra_kale]

Hi,

Below given is the sample data in which for one Policy there are Two or Three Premium values. I want a maximum value for that policy only through script so that will become my base data for further calculation.

Please suggest how I can achieve this in script

Policy_no	Premium	Name
12345678	5000	Jon
10002345	100000	Joseph
12345688	40000	Kern
12345278	60000	Ritu
12345678	3000	Jon
10002345	200000	Joseph
12345688	60000	Kern
12345278	40000	Ritu
12345688	100000	Kern
12345278	800000	Ritu
5678945	25000	Jeevan
369874	123980	Kiran

Final Out_put should be like this..

Policy_no	Premium	Name
12345678	5000	Jon
10002345	200000	Joseph
12345688	100000	Kern
12345278	800000	Ritu
5678945	25000	Jeevan
369874	123980	Kiran

Thanks in advance..

[petter]

Happy to help Please mark the question as answered so the thread can be closed.

[timsaddler]

Very good thread Petter - rescued me from a difficult situation

Thank you