andyeaston
New Member
- Joined
- Sep 20, 2016
- Messages
- 16
I have a sheet of about 1000 rows ...
So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is removing rows when just one of the Slave orders has a Status of 12, 13, or 14 or a Type of 02 I need to remove every instance of that Master order.
Ive been working on this for a few days and the problem is when I have more than 2 Slave orders I run into trouble.
If I need to explain further, please let me know.
Thank you
below is an example of what I start with
<tbody>
</tbody>
below is an example of the desired result....
<tbody>
</tbody>
So there are 11 rows of Master Order numbers but only 5 different Master Orders. Some Master orders have Slave orders, some do not. If a Master order has a Status of 12, 13 or 14 or a Type of 02 I need to remove that row. The problem Im having is removing rows when just one of the Slave orders has a Status of 12, 13, or 14 or a Type of 02 I need to remove every instance of that Master order.
Ive been working on this for a few days and the problem is when I have more than 2 Slave orders I run into trouble.
If I need to explain further, please let me know.
Thank you
below is an example of what I start with
Master Order | Slave Order Number | Status | Type | ||
545251 | 545251 | 00 | 02 | ||
582390 |
<tbody> </tbody> | 00 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 02 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 01 | ||
584076 |
<tbody> </tbody> | 14 | 01 | ||
585155 |
<tbody> </tbody> | 00 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 12 | 02 | ||
587638 |
<tbody> </tbody> | 00 | 01 | ||
<tbody>
</tbody>
below is an example of the desired result....
Master Order | Slave Order Number | Status | Type | ||
<tbody> </tbody> |
<tbody> </tbody> | 20 | 01 | ||
<tbody> </tbody> |
<tbody> </tbody> | 00 | 01 |
<tbody>
</tbody>
Last edited: