<body><p>Hi,</p> <p> </p> <p>pls help me on below scenario. </p> <p> <tr height="17"> <td width="64" class="xl25" height="17">Lan</td> <td width="64" class="xl25">Date</td> <td width="64" class="xl25">Bucket</td> <td width="217" class="xl25">Expected Value in these column</td> <td width="226"></td> </tr> <tr height="17"> <td align="right" height="17">1</td> <td x:num="40391" align="right" class="xl24">1-Aug-10</td> <td align="right">0</td> <td align="right">0</td> <td></td> </tr> <tr height="17"> <td align="right" height="17">1</td> <td x:num="40392" align="right" class="xl24">2-Aug-10</td> <td align="right">2</td> <td align="right">2</td> <td></td> </tr> <tr height="17"> <td align="right" height="17">1</td> <td x:num="40393" align="right" class="xl24">3-Aug-10</td> <td align="right">1</td> <td align="right" class="xl25">2</td> <td>Need to have the highest above Max value for a particular Lan No</td> </tr> <tr height="17"> <td align="right" height="17">1</td> <td x:num="40394" align="right" class="xl24">4-Aug-10</td> <td align="right">3</td> <td align="right" class="xl25">3</td> <td>Need to have the highest above Max value for a particular Lan No</td> </tr> <tr height="17"> <td align="right" height="17">1</td> <td x:num="40395" align="right" class="xl24">5-Aug-10</td> <td align="right">0</td> <td align="right" class="xl25">3</td> <td>Need to have the highest above Max value for a particular Lan No</td> </tr> <tr height="17"> <td align="right" height="17">2</td> <td x:num="40396" align="right" class="xl24">6-Aug-10</td> <td align="right">0</td> <td align="right">0</td> <td></td> </tr> <tr height="17"> <td align="right" height="17">2</td> <td x:num="40397" align="right" class="xl24">7-Aug-10</td> <td align="right">6</td> <td align="right">6</td> <td></td> </tr> <tr height="17"> <td align="right" height="17">2</td> <td x:num="40398" align="right" class="xl24">8-Aug-10</td> <td align="right">1</td> <td align="right" class="xl25">6</td> <td>Need to have the highest above Max value for a particular Lan No</td> </tr> <tr height="17"> <td align="right" height="17">2</td> <td x:num="40399" align="right" class="xl24">9-Aug-10</td> <td align="right">7</td> <td align="right" class="xl25">7</td> <td>Need to have the highest above Max value for a particular Lan No</td> </tr> <tr height="17"> <td align="right" height="17">2</td> <td x:num="40400" align="right" class="xl24">10-Aug-10</td> <td align="right">2</td> <td align="right" class="xl25">7</td> <td> <p>Need to have the highest above Max value for a particular Lan No</p> <div></div> </td> </tr> </p> <p>In the above scenario how to use above function or let me know some other alternatives</p> <p> </p> <p>Thanks & Regards</p> <p>Arun </p> <p><col span="3" width="64"></col> <col width="217"></col> <col width="226"></col> <tr height="17"> <td width="64" class="xl25" height="17"></td> <td width="64" class="xl25"><br /></td> <td width="64" class="xl25"><br /></td> <td width="217" class="xl25"><br /></td> <td width="226"><br /></td> </tr> </p> <p><col span="3" width="64"></col></p></body>
