Forum Discussion
Input 1 to 7 SKU numbers to return groups of rows.
My actual document has 300 cases of product listed in rows, I trimmed it down to 20 cases of product for this example and replaced the names for confidentiality.
I want to be able to input these three components 9800006353, 9800006357, 9800006356 and return rows 3-6, 12-15, 24-27. Because the Case SKU in column A has more than just those three components.
I want to be able to do this with any of the hundred or so components exist and then return the Case SKU with all of the Component rows.
First image is what it would like to start with, then I would input the three components 9800006353, 9800006357, 9800006356 and the second image is what I am looking for.
Second image below.
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.
select * from Sheet1;
create temp table aa as
select colIdxf[0:1]{udf_fillna_m(%s,"a%s") %s},f03,f04,f05 from Sheet1;
create temp table bb as
select f01 from aa where regexp('9800006353|9800006357|9800006356',cast(f03 as text)) group by f01 having(count(f03)=3);
create temp table cc as
select * from bb inner join aa using(f01);
//select * from cc;
cli_merge_row~cc~2;
