Hi,
I have attached a sample spreadsheet to better explain what needs to happen.
In the spreadsheet, I have a table that is generated by SQL. Form this table I need to pull out certain sections. The Sections that I need to pull out are in the table next to it in yellow.
I need to type in base (in this case W128636; This will populate the table) and SubNo (in this case 5), the result needs to be a list of rsc.
I have tried the following array: {=IFERROR(INDEX($E$2:$E$41,MATCH(0,IF($H3=$C2:$C41,COUNTIF($H3:H3,$E$2:$E$41),""),0)),"")}
This array work except it removes all duplicates and I need it to display everything preferably in a column (highlighted in yellow) instead of a row.
(BASE WILL NEVER CHANGE, ONLY subNo)
Thank you
Bookmarks