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.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

As well as reading the rule and the linked page mentioned above, please provide links to all threads on any forum where you have asked this question.

 

[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.

 

[Peter_SSs]

I thought that was the links.

They are not links. This is an example of a link (to a thread that you started in June)

How do you write the formula in Cell F1?

www.mrexcel.com

The links need to be such that if a reader here wants to see your question and what has been suggested in another forum they can click the link and be taken to that exact thread in the other forum.

So how do you make it a link

Go to the thread in the other forum(s) and copy the address from your browser address bar and paste it here.

 

[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?

forums.excelguru.ca

Chandoo.org

How do I do the opposite of FILTER formula in Cell L2?

MrExcel.com:

Please help with FILTER Formula.

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...

www.mrexcel.com

Msofficeforums.com:

Please help with FILTER formula

Please help with FILTER formula Excel

www.msofficeforums.com

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

Are you stuck doing a tedious manual process day after day? This can be automated using VBA macros behind your Excel worksheets. For over twenty years, these Excel consultants work with customers via e-mail or telephone to build a solution.

www.mrexcel.com

 

[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.

Sorry for the very late reply. I needed to back off from Excel formulas. I was completely burned out. I would very much just like to utilize the FILTER formula (Excel version 2021) because I can understand it better than not using a FILTER formula at all. I have to use it on other parts of the worksheet that uses 200 columns and 10 rows. And that's just one table of an array out of 20 to 30 arrays. So that's why I just sent a short version ( Dec 3, 2024 - #1 post of this forum) so it would be easier to do but found out that the formulas that excel helpers wrote didn't work accordingly to plan.

 

[etaf]

So you have links to FILTER
are you stuck still ???

thats usually good to make a small representative sample

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

Images

Images are difficult to see , and also requires that I input all the data myself, which means I may make an error, which is very time consuming, and from my point of view less likely to get a response, if a complicated spreadsheet. Plus we cannot see any of the formulas used.

Therefore:-

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[arthurz11]

I received an error trying to download XL2BB. Something about an error being protected so I was unable to download. Anyway, I wrote the explanation on the worksheet. Please view image.
The links are in Post #5 dated December 6, 2024. Please use this sample of image because the others was not that well explain on the results I wanted.

 

[etaf]

SORRY
As I mentioned , images are difficult to read , I only have a 13" screen , and also i cannot test out or see formulas used and try things out
if xl2bb is not working , as mentioned there is a forum to get help on that
Otherwise , again as mentioned, post on a share
I only open Dropbox, onedrive or google sheets

 

[arthurz11]

SORRY
As I mentioned , images are difficult to read , I only have a 13" screen , and also i cannot test out or see formulas used and try things out
if xl2bb is not working , as mentioned there is a forum to get help on that
Otherwise , again as mentioned, post on a share
I only open Dropbox, onedrive or google sheets

May I send it by email? I can do that.