Forum Discussion
Input 1 to 7 SKU numbers to return groups of rows.
It is strongly recommended not to use merged cells. You may use COUNTIFS() with FILTER() function to get desired result. See the attached file.
=FILTER(A2:E29,COUNTIFS(I2:I4,C2:C29))
Hi Harun24HR, THANK YOU!!! I attached a pic of your file below and mocked up what I'm looking for under your results. I want to return all rows for the SKU, not just the rows I searched for. Also, I put a boarder around each SKU set, is there a way to do this, or maybe a conditional format to color the different SKU sets so you can tell them apart quickly?
Also, the results must contain at least both inputs. I don't want to see results if only one of the components is in the SKU.
I'm sorry, it won't let me attached a new spreadsheet.
Please attach a sample file.
Harun23HR. File attached. Thank you again! I think all I need now is just the border around the SKU sets that are returned, your current formula works. It doesn't need to be a border, it could be different colors for different SKU sets, just something to differentiate them so they don't all blur together.
