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!?!?!?!? I recently have asked (9) msofficeforums.com. This makes my ninth 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.

 

[etaf]

No sorry, i do not accept anything offline - the file / sample or xl2bb - needs to be on the forum as a post, so others can help and also if wrong solution others can put right

 

[Peter_SSs]

May I send it by email?

In post #2 in this thread I referred you to the forum rules. Please actually read them. #4 clearly states that you cannot do that.

 

[arthurz11]

SOLUTION: By djc dated 12/16/2024. Page 1 - Post #24 and Page 2 - Post #27 from Chandoo.org.
LINK:
How do I do the opposite of FILTER formula in Cell L2?