Need Help Deleteing 1 row from each group of Data

[TobyStuder]

I know my mind is blocked on this but i don't know where to even start. I have a dataset that is for employee travel that when this pay code is used you get paid for all days except the last one. i have been able to filter out the paycode and now have one line for each employee each day. My issue now is how do I remove 1 row. They may work this job 1 to 7 days. if they work it 1 day of course that is not removed but if they work 2 or more the last day is removed.

Example:

[TABLE="width: 146"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/13/2018[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/14/2018[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/15/2018[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/16/2018[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/17/2018[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/13/2018[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/14/2018[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/15/2018[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/16/2018[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/17/2018
[/TD]
[/TR]
</tbody>[/TABLE]

for these two employees would both have the 8/17/2018 rows removed. So, i have 27 different employees to anaylze. Here is the whole dataset

[TABLE="width: 412"]
<colgroup><col><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Employee[/TD]
[TD]Date[/TD]
[TD]Job[/TD]
[TD]Cost Code[/TD]
[TD]Units[/TD]
[TD]Pay ID[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ALLJEF[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJAI[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJOR[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]07-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJOR[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7064[/TD]
[TD]07-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJOR[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJOR[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJOR[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJUA[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJUA[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJUA[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJUA[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11BECJUA[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CANDAN[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CANDAN[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CANDAN[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CANDAN[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CANDAN[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CERJOE[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CERJOE[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CERJOE[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CERJOE[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11CERJOE[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIESAN[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIESAN[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIESAN[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIESAN[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIESAN[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIZFRA[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIZFRA[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIZFRA[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIZFRA[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11DIZFRA[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FUNNAT[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FUNNAT[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FUNNAT[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FUNNAT[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FUNNAT[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-204[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GARFER[/TD]
[TD="align: right"]8/18/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GILJOH[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-204[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GILJOH[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]12-14-4434[/TD]
[TD]06-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GILJOH[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GILJOH[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GILJOH[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTEDU[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-18-8018[/TD]
[TD]17-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTEDU[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTEDU[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTEDU[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTEDU[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTPOR[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-214[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTPOR[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTPOR[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTPOR[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11GUTPOR[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11HOFDAN[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11HOFDAN[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11HOFDAN[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11HOFDAN[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11HOFDAN[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ITZEGA[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7009[/TD]
[TD]17-804[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ITZEGA[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ITZEGA[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ITZEGA[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ITZEGA[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11LOPEJO[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11LOPEJO[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11LOPEJO[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11LOPEJO[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11LOPEJO[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MARMJO[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MARMJO[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MARMJO[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MARMJO[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MARMJO[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MONALB[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MONALB[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MONALB[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MONALB[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MONALB[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11NEGJON[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11NEGJON[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11NEGJON[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11NEGJON[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11NEGJON[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7053[/TD]
[TD]05-035[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ORTJEN[/TD]
[TD="align: right"]8/18/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBJOS[/TD]
[TD="align: right"]8/18/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBSTE[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBSTE[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]12-14-4434[/TD]
[TD]06-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBSTE[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBSTE[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11ROBSTE[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7064[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SALEDW[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SALEDW[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SALEDW[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SALEDW[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SALEDW[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SBRDAN[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-050[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SBRDAN[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SBRDAN[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SBRDAN[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11SBRDAN[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11VERCRU[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7009[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11VERCRU[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11VERCRU[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11VERCRU[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11VERCRU[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7009[/TD]
[TD]18-802[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11WRIJAS[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11WRIJAS[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11WRIJAS[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11WRIJAS[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11WRIJAS[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7022[/TD]
[TD]06-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MEDAUG[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MEDAUG[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MEDAUG[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MEDAUG[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11MEDAUG[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-17-7056[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FERSER[/TD]
[TD="align: right"]8/13/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FERSER[/TD]
[TD="align: right"]8/14/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FERSER[/TD]
[TD="align: right"]8/15/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FERSER[/TD]
[TD="align: right"]8/16/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
[TR]
[TD]11FERSER[/TD]
[TD="align: right"]8/17/2018[/TD]
[TD]11-18-8018[/TD]
[TD]05-045[/TD]
[TD="align: right"]1.00[/TD]
[TD]553[/TD]
[/TR]
</tbody>[/TABLE]

any help or ideas would be awsome. I have looked all over the internet and haven't found anything helpful yet. I have never posted on one of these boards so please let me know what else is needed.

Regards,

 

[Yongle]

Welcome to the forum Toby

With your values in Columns A:F try this in G2 copy down

=IF(COUNTIF(A:A,A2)=1,"",IF(MAXIFS(B:B,A:A,A2)=B2,"XX",""))

 

[TobyStuder]

Thanks this formula works perfectly. I knew I was making it harder than is was.