IF Formula to Highlight Sales Order

[MEDIUMRARESTEAK]

Hi, I'm trying to filter for sales order numbers that have a SPLIT sku in the entire order. I used a simple =IF(F2<>G2,"SPLIT","OK") to identify individual skus but obviously, trying to filter just for splits won't show the entire order associated with it. I think I'd have to create two columns of formulas but I can't isolate the sales order when it has both OK and SPLIT skus. In the example below, the split shipment is in bold and associated with SO# 807834561. The =IF formula capture the row but now I need to be able to filter for that split to show all the skus in the SO#.

SALES ORDER # SKU DC1 DC2 SHIPPED_DATE Status
807834552 Z7W440 CA CA 12/7/2016 OK
807834552 777085 CA CA 12/7/2016 OK
807834552 ZJ4R01 CA CA 12/7/2016 OK
807834559 Z7W440 CA CA 12/7/2016 OK
807834559 777123 CA CA 12/7/2016 OK
807834559 Z21801 CA CA 12/7/2016 OK
807834561 Z9FF23 CA NY 12/5/2016 SPLIT
807834561 Z7W440 CA CA 12/7/2016 OK
807834561 777490 CA CA 12/7/2016 OK
807834561 Z9FF21 CA CA 12/7/2016 OK

[bebo021999]

Like this:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Untitled.png

[MEDIUMRARESTEAK]

Like this:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Attachment 502498

This did it! Thank you so much for your help!! I have to understand how sumproduct works in this.