Please help with FILTER formula

[arthurz11]

I’ve been working on this for months and yet not one person from the following paying and help Excel forums have not come up with a solution. I was even scammed by two paying help websites. The following that had helped: (1) Mrexcel.com, (2) Excel Help Forum, (3) Paperial.com, (4) Chandoo.org, (5) Excelguru.ca Forums, (6) TutorBin.com, (7) Mrexcel.com from Consultants Services feature and (8) Nerdifyit.com. Some came up with solutions using Excel 365 and Excel Version 2024 but not for Excel version 2021 which I am utilizing. Please help. Anyone!?!?!?!? This is my first time asking (8) msofficeforums.com. This makes my eighth website/forum for help.


Please note: The FILTER formula in cell N2 was created by JamesCanale, Well-known Member of Mr.Excel.com but haven’t heard from him for a while.
See attached Excel File.

[Pecoflyer]

Cross-posting is not forbidden but forum courtesy requires that you post a link to ALL threads in other forum. Read A message to forum cross posters - Excelguru to understand why. Thanks

[arthurz11]

Hi!

I wrote the .com or .ca or .org on the tread. I thought that was the links. Unless you mean change the text to blue color to indicate it is linked but I know that will not work by changing the color text to blue. So how do you make it a link so ???

Arthur.

[Pecoflyer]

Open your thread in each forum, copy the link (URL) and post it here.

[kvsrinivasamurthy]

The VBA code is ok or you need formula only.

[kvsrinivasamurthy]

In N2 copied uptoV4
=GetCoordinates($A2:$J2,$M2,COLUMNS($N2:N2))

Here is the code for UDF.

Function GetCoordinates(Ip As Range, cri As String, Ind As Integer)

Dim Tc&, Td&, clms&, S$, Y&
Dim M
With CreateObject("Scripting.dictionary")
clms = Ip.Columns.Count
If clms < 2 Or clms Mod 2 <> 0 Then Exit Function
ReDim R(1 To clms)
    For Tc = 1 To clms Step 2
    S = Ip.Cells(1, Tc) & "," & Ip.Cells(1, Tc + 1)
    If S <> "," And S <> "" Then
       If cri = "Unique" Then
            If Not .exists(S) Then
            .Item(S) = "Y"
            End If
       ElseIf cri = "Duplicates" Then
            If .exists(S) Then
            .Item(S) = "Y"
            Else
            .Item(S) = "N"
            End If
       ElseIf cri = "Non Duplicates" Then
            If .exists(S) Then
            .Item(S) = "N"
            Else
            .Item(S) = "Y"
            End If
        End If
    S = ""
    End If
    Next Tc
    
    For Td = 0 To .Count - 1
    If .items()(Td) = "Y" Then
    ReDim Preserve R(1 To Y + 2)
    M = Split(.keys()(Td), ",")
    R(Y + 1) = M(0): R(Y + 2) = M(1): M = ""
    Y = Y + 2
    End If
    Next Td

End With
If Y >= Ind Then
GetCoordinates = R(Ind)
Else
GetCoordinates = ""
End If
End Function

How to Use UDF code:
In the developer tab click--> Visual Basic
VB window opens
Insert--> Module
Paste the code.
Close the VB window.
Now UDF is available in Function List
This function can be used like other functions in excel.
Save file as .xlsm

[arthurz11]

Thank you sooo much for your effort. However, I do not know VBA codes on Excel. I had cross posted and I was told to show the links from the previous threads. So it is the utlmost importantance that I utilize a FILTER formula. So here are the following links to other threads...

Excelguru.ca:
How do I write the FILTER formula to do the opposite in Cell L2? | Excelguru Forums

Chandoo.org
How do I do the opposite of FILTER formula in Cell L2? | Chandoo.org Excel Forums - Become Awesome in Excel

MrExcel.com:
Please help with FILTER Formula. | MrExcel Message Board

Msofficeforums.com:
https://www.msofficeforums.com/excel...tml#post184219

Paid website my.paperial.com (Unable to write a solution):
Add Your Task Details - Paperial.com

Paid website student.tutorbin.com (Unable to write a solution):
Student Dashboard

Paid website Nerdifyit.com (Unable to write a solution):
Nerdify | #1 Learning Help for College Students

Pay MrExcel.com consultant services (Brian Field email a FILTER formula and he told me that I didnÂ’t have to pay. But I email back to show the errors on the formula but he never reply by email:
Consulting Services - MrExcel Publishing

[Pecoflyer]

Your thread at How do I write the FILTER formula to do the opposite in Cell L2? | Page 2 | Excelguru Forums seems to be progressing fine, you are getting lots of (most patient) help from Ali. Your last reply there dates from yesterday,and I am certain she will work on it.So why start a thread in the nth forum?

[arthurz11]

SOLUTION: By djc dated 12/16/2024. Page 1 - Post #24 and Page 2 - Post #27 from Chandoo.org.

LINK:
​https://chandoo.org/forum/threads/how-do-i-do-the-opposite-of-filter-formula-in-cell-l2.57834/

[Pecoflyer]

Thanks for the heads up. Please mark this thread as solved. Thx

[arthurz11]

Originally Posted by Pecoflyer

Thanks for the heads up. Please mark this thread as solved. Thx

Where do I click to say problem is solved?

[Pecoflyer]

See "thread tools"