Delete if matching

[shadow12345]

This one is pretty simple to explain but im not even sure its possible.

Time stamps in column A, Reference numbers in column E

I would like to check the time stamps in A... then delete all of the rows if the references number in E are all the same.

For example in the below, rows 2-5 should be deleted, everything else should be left.
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0"><b>A</b></td><td align="center" bgcolor="#C0C0C0"><b>B</b></td><td align="center" bgcolor="#C0C0C0"><b>C</b></td><td align="center" bgcolor="#C0C0C0"><b>D</b></td><td align="center" bgcolor="#C0C0C0"><b>E</b></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>1</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Time </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Ref </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>2</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">123 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>3</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">123 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>4</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">123 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>5</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:15 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">123 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>6</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:16 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">121 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>7</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:16 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">125 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>8</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:02:16 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">121 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>9</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:17:26 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">321 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>10</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:17:26 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">321 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>11</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:17:26 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">241 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>12</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:17:26 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">687 </font></td></tr>
<tr><td align = "center" bgcolor="#C0C0C0"><b>13</b></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">09:17:26 </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000"> </font></td><td rowspan="1" colspan="1" width="96" height="30" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">123 </font></td></tr>
</table>

Anyone care to take a crack ... or point me in the right direction and ill give it a whirl.

 

[Tom Urtis]

Based on your stated logic, please explain why rows 9 and 10 should not be deleted.

 

[AlphaFrog]

I don't follow why delete only rows 2 to 5 ?
Rows 6 and 8 match each other as well as rows 9 and 10.

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Time </td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;">Ref </td><td style=";">Is Duplicated</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="text-align: center;background-color: #FFFF99;;"> </td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="text-align: center;background-color: #FFFF99;;"> </td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="text-align: center;background-color: #FFFF99;;"> </td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;background-color: #CCFFCC;;">09:02:16</td><td style="text-align: center;background-color: #CCFFCC;;"> </td><td style="text-align: center;background-color: #CCFFCC;;"></td><td style="text-align: center;background-color: #CCFFCC;;"></td><td style="text-align: center;background-color: #CCFFCC;;">121</td><td style="text-align: right;background-color: #CCFFCC;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;;">09:02:16</td><td style="text-align: center;;"> </td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">125</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;background-color: #CCFFCC;;">09:02:16</td><td style="text-align: center;background-color: #CCFFCC;;"> </td><td style="text-align: center;background-color: #CCFFCC;;"></td><td style="text-align: center;background-color: #CCFFCC;;"></td><td style="text-align: center;background-color: #CCFFCC;;">121</td><td style="text-align: right;background-color: #CCFFCC;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;background-color: #99CCFF;;">09:17:26</td><td style="text-align: center;background-color: #99CCFF;;"> </td><td style="text-align: center;background-color: #99CCFF;;"></td><td style="text-align: center;background-color: #99CCFF;;"></td><td style="text-align: center;background-color: #99CCFF;;">321</td><td style="text-align: right;background-color: #99CCFF;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;background-color: #99CCFF;;">09:17:26</td><td style="text-align: center;background-color: #99CCFF;;"> </td><td style="text-align: center;background-color: #99CCFF;;"></td><td style="text-align: center;background-color: #99CCFF;;"></td><td style="text-align: center;background-color: #99CCFF;;">321</td><td style="text-align: right;background-color: #99CCFF;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;;">09:17:26</td><td style="text-align: center;;"> </td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">241</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;;">09:17:26</td><td style="text-align: center;;"> </td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">687</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;;">09:17:26</td><td style="text-align: center;;"> </td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">123</td><td style="text-align: right;;">FALSE</td></tr></tbody></table><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F2</th><td style="text-align:left">=SUMPRODUCT(<font color="Blue">--(<font color="Red">$A$2:$A$13=A2</font>),--(<font color="Red">$E$2:$E$13=E2</font>)</font>)>1</td></tr></tbody></table></td></tr></table><br />

You could use the above formula (or a COUNTIFS formula if you have Excel 2007 or later) to tag the duplicates. Then use the AutoFilter feature to filter the "TRUE" rows and then delete them.

 

[shadow12345]

Sorry perhaps its not quite as clear... if there is any differece in the reference numbers then keep ALL of the rows in the timestamp, not just the ones that are duplicated

 

[shadow12345]

Based on your stated logic, please explain why rows 9 and 10 should not be deleted.

Row 9 and 10 should not be deleted because 11 12 13 are in the same time stamp and are different thus I want to retain all of the rows.

 

[AlphaFrog]

Would this work for you?
<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Time </td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;">Ref </td><td style=";">One Ref in Time Stamp</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;background-color: #FFFF99;;">09:02:15</td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="font-weight: bold;text-align: center;background-color: #FFFF99;;"></td><td style="text-align: center;background-color: #FFFF99;;">123</td><td style="text-align: right;background-color: #FFFF99;;">TRUE</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;;">09:02:16</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">121</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;;">09:02:16</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">125</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;;">09:02:16</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">121</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;;">09:17:26</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">321</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;;">09:17:26</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">321</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;;">09:17:26</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">241</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;;">09:17:26</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">687</td><td style="text-align: right;;">FALSE</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;;">09:17:26</td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="font-weight: bold;text-align: center;;"></td><td style="text-align: center;;">123</td><td style="text-align: right;;">FALSE</td></tr></tbody></table><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">F2</th><td style="text-align:left">=AND(<font color="Blue">SUMPRODUCT(<font color="Red">--(<font color="Green">$A$2:$A$13=A2</font>),--(<font color="Green">$E$2:$E$13=E2</font>)</font>)=COUNTIF(<font color="Red">$A$2:$A$13,A2</font>),COUNTIF(<font color="Red">$A$2:$A$13,A2</font>)>1</font>)</td></tr></tbody></table></td></tr></table><br />

 

[shadow12345]

It would... it does ... it has...


Thanks so much, now I will tinker on my sheet to get this working.