</SPAN></SPAN></SPAN></SPAN>Hey Guys,
Consider this scenario.</SPAN>
Consider the following table with these entries:</SPAN>
<TBODY>
</TBODY>
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>
<TBODY>
</TBODY>
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>
Name</SPAN></SPAN> | number1</SPAN></SPAN> | number2</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 1</SPAN></SPAN> | 4</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 1</SPAN></SPAN> | 1</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 2</SPAN></SPAN> | 6</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 1</SPAN></SPAN> | 9</SPAN></SPAN> |
Singh</SPAN></SPAN> | 2</SPAN></SPAN> | 3</SPAN></SPAN> |
Singh</SPAN></SPAN> | 5</SPAN></SPAN> | 5</SPAN></SPAN> |
Singh</SPAN></SPAN> | 6</SPAN></SPAN> | 8</SPAN></SPAN> |
Singh</SPAN></SPAN> | 7</SPAN></SPAN> | 7</SPAN></SPAN> |
Singh</SPAN></SPAN> | 9</SPAN></SPAN> | 9</SPAN></SPAN> |
<TBODY>
</TBODY>
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>
Name</SPAN></SPAN> | number1</SPAN></SPAN> | number2</SPAN></SPAN> |
Abhinav</SPAN></SPAN> | 1</SPAN></SPAN> | 9</SPAN></SPAN> |
Singh</SPAN></SPAN> | 2</SPAN></SPAN> | 9</SPAN></SPAN> |
<TBODY>
</TBODY>
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>