</SPAN></SPAN></SPAN></SPAN>Hey Guys,
Consider this scenario.</SPAN>
Consider the following table with these entries:</SPAN>
[TABLE="width: 221"]
<TBODY>[TR]
[TD]Name</SPAN></SPAN>
[/TD]
[TD]number1</SPAN></SPAN>
[/TD]
[TD]number2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]4</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]6</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]5</SPAN></SPAN>
[/TD]
[TD]5</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]6</SPAN></SPAN>
[/TD]
[TD]8</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]7</SPAN></SPAN>
[/TD]
[TD]7</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
As you can see there are duplicate entries.</SPAN>
I want to sort it in such a way that under the name column I have</SPAN>
All the unique entries and under the other two columns, number1 displaying the</SPAN>
Least value and number2 displaying the highest value pertaining to each unique entry.</SPAN>
Here is an example:</SPAN>
[TABLE="width: 221"]
<TBODY>[TR]
[TD]Name</SPAN></SPAN>
[/TD]
[TD]number1</SPAN></SPAN>
[/TD]
[TD]number2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
If this is possible, it can really help me in generating daily reports.</SPAN>
Please look into this issue and reply asap.</SPAN>
Thank You</SPAN>
Consider this scenario.</SPAN>
Consider the following table with these entries:</SPAN>
[TABLE="width: 221"]
<TBODY>[TR]
[TD]Name</SPAN></SPAN>
[/TD]
[TD]number1</SPAN></SPAN>
[/TD]
[TD]number2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]4</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]6</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]5</SPAN></SPAN>
[/TD]
[TD]5</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]6</SPAN></SPAN>
[/TD]
[TD]8</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]7</SPAN></SPAN>
[/TD]
[TD]7</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
As you can see there are duplicate entries.</SPAN>
I want to sort it in such a way that under the name column I have</SPAN>
All the unique entries and under the other two columns, number1 displaying the</SPAN>
Least value and number2 displaying the highest value pertaining to each unique entry.</SPAN>
Here is an example:</SPAN>
[TABLE="width: 221"]
<TBODY>[TR]
[TD]Name</SPAN></SPAN>
[/TD]
[TD]number1</SPAN></SPAN>
[/TD]
[TD]number2</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Abhinav</SPAN></SPAN>
[/TD]
[TD]1</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Singh</SPAN></SPAN>
[/TD]
[TD]2</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]
If this is possible, it can really help me in generating daily reports.</SPAN>
Please look into this issue and reply asap.</SPAN>
Thank You</SPAN>