0

Unfortunatly due to security I cannot share the page, but I am using the following codes:

=ARRAY_CONSTRAIN(
ARRAYFORMULA(iferror(
TEXTJOIN(",",TRUE,unique(IF(($D4=Section!C$2:AW$2),Section!C$3:AW$4,"")),"")
))
, 1, 1)
=ARRAY_CONSTRAIN(
ARRAYFORMULA(
TEXTJOIN(",",TRUE,if(A1="","",Unique(IF(query((MDS!$E$4:$CU$4="TRUE")*(Import!$D$1=MDS!A:A)*(A1=MDS!E:CU)),query(MDS!C:C),"")))))
, 1, 1
)

Which works great aside from the unique not working. When I try and add unique at the end it tells me that the ranges don't align. Which is because I am trying to get rid of Duplicates. I have tried searching online, and have tried creating a separate column(s) using:

=iferror(sort(unique(TRIM(transpose(split(textjoin(",",true,iferror(split(C1,","))),"|"))))),"")

To the same issue still am not able to get rid of duplicates, that account for everything. Say one cell has NYC, NYC, another has ESC, ESC. Then there is another one that has Con, Con, ESC and that causes more issues, as sometimes it is only 1 name others it can be up to 10 duplicates in the same cell. Can anyone assist me with this please?

  • Welcome. Please create a demo spreadsheet, include sample data, share it with anyone with the link and add the link to the question. – Rubén Nov 18 at 19:23
  • There is no security reason you cant take the time to replicate a new sheet with fake sample data. Also include a hard coded how you want the output to be and your current progress showing what you wanted vs what you have. By taking the time to do this we can isolate the problem so we know what to solve because understanding your question is a problem in itself. – CodeCamper Nov 18 at 19:48
  • docs.google.com/spreadsheets/d/… I would like all duplicates to be removed. 1 of each is fine. This is a quick throw together (hard to do the full sheet as it is alot more data then what is showing here. This is only based on 2 hours. – Devilsplay Nov 18 at 20:23
  • @Devilsplay make link public – CodeCamper Nov 18 at 22:19
  • I just did, should have been available. docs.google.com/spreadsheets/d/… – Devilsplay Nov 19 at 4:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.