Hello, I have sales data for a certain period. Within the period, the data shows delivery information for each order. Column A shows the Order # and column B shows the Delivery #.
Delivery # equal to 0 indicates the original delivery for that Order #. I want to filter my data to show all delivery information for Orders which had their original delivery in the period. So, if an Order # has delivery information, but none of the delivery #'s are equal to 0, then I want to filter that data out.
Sample data is here. I appreciate any and all assistance!! Thank you.
<a href=http://www.filedropper.com/sampledata><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >file backup online</a></div>
Delivery # equal to 0 indicates the original delivery for that Order #. I want to filter my data to show all delivery information for Orders which had their original delivery in the period. So, if an Order # has delivery information, but none of the delivery #'s are equal to 0, then I want to filter that data out.
Sample data is here. I appreciate any and all assistance!! Thank you.
<a href=http://www.filedropper.com/sampledata><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >file backup online</a></div>
