Textjoin() and Match() Formula Issue

For some reason, this formula seems to only "partially" work.

Formula:

Please Login or Register  to view this content.

I can't post the entire workbook because it's company info. But in a nutshell, I have a powerquery set up to pull information from our datawarehouse. There are multiple activities per well. There are multiple wells per well pad. Illustrated by this picture.

2019-10-23_11-57-09.png

I then have a "summary" type sheet that puts each well pad on one line. I have a column for "Wells on Pad". The formula is intended to go lookup the well pad ID in column I, match it against the well pad ID in the sheet from the picture above, then give me only unique values for the Well Numbers in 1 cell. The odd thing is, it has worked for a lot of the well pads. But, there are several that are blank all together (and shouldn't be), or have a couple of the well numbers, but not all. What am I missing in this formula? Below is a picture of the "result" I am after.

2019-10-23_12-02-01.png

Any help would be greatly appreciated. I am so confused why it's working some of the time, but not for all. Basically any line item that has a well pad ID should have at least 1 result in the Wells on Pad column.

Thanks in advance,

Chris

Thank you so much for the guidance, Ali. I will re-post in just a few minutes!!

Okay, let's try again. I am attaching the workbook. I believe I removed everything except the relevant columns. Column B on the tab "Summary Page" is the formula I am trying to address. Column C is the expected result of the formula. In most cases, it works fine. I have about another 2000 rows other than what's being shown here, so these aren't the "only" ones that aren't right, just a sample.

Summary Page


C2=IFERROR(TEXTJOIN(" ,",TRUE,UNIQUE(FILTER('PQ from DW'!$C$2:$C$1026,'PQ from DW'!$D$2:$D$1026='Summary Page'!$A2))),"")

Hello Caracalla,

I believe I am plugging this in as written, I am getting "That function isn't valid". When I click "okay", it highlights the "FILTER" in the formula. No idea if that's relevant...but also noticed that the "autocomplete" when writing the formula didn't come up for the words "Unique" or "Filter". Is there some checkbox somewhere I need to enable the capabilities? Thanks again for your reply!

You are amazing, FR! Thank you so much. I got them to work both in the test and with the live data! Thank you again and everyone else for your input.