Dear Peter,
Thanks for replying
First no same name will have same age as I have made the data that way.
I get the data where the persons in groups of 4 or 5 travel and they enter their names in a cell.
I use the text to column to get the names in separate columns
Then assign a leader of the group according to the highest aged person in the next column.
the result should be in the sheet where the rows are.
Like below
<!-- Please do not remove this header -->
<!-- Table easily created from Excel with ASAP Utilities (
http://www.asap-utilities.com) -->
<table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellspacing="0" align="center" frame="border">
<tr>
<td bgcolor="#FFFFFF" width="63" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="63" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="77" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="75" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000"></font></td>
<td bgcolor="#FFFFFF" width="78" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Result</font></td>
<td bgcolor="#FFFFFF" width="63" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Result</font></td>
</tr>
<tr>
<td bgcolor="#FFFFFF" width="63" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Sam</font></td>
<td bgcolor="#FFFFFF" width="63" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">John</font></td>
<td bgcolor="#FFFFFF" width="63" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Jack</font></td>
<td bgcolor="#FFFFFF" width="77" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">George Paul</font></td>
<td bgcolor="#FFFFFF" width="75" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">Mathew Joy</font></td>
<td bgcolor="#FFFFFF" width="78" height="21" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">George Paul</font></td>
<td bgcolor="#FFFFFF" width="63" height="21" align="right" valign="bottom" style="white-space: nowrap"><font face="Tahoma" size="2" color="#000000">85</font></td>
</tr>
</table>
Thanks