Justin, I'm not sure I completely understand your question/desired result, but you may be looking for something like this in a calculated field:
IF [Column In/Out] THEN [ORDERNO] END
This assumes [Column In/Out] is your set, which will return a Boolean value. If this doesn't work, mock up some data and post a packaged workbook and we'll take a look.
Thanks for the response. I am simplifying to three columns.
I have the order number, whether or not the SELLING SKU is a refund SKU, and the selling SKUS for each order.
What I am needing is to filter so that if an order contains a refund SKU (YES), then that order will show up with all SELLING SKUS, including those that aren't refund SKUS. The picture below should help. I need all yellow data to be displayed and filtered out all gray rows (those orders with no refund SKUS at all).