Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Option for FILTER ISNA MATCH but for sensitive case and can be used on columns with different total rows

To access the Google Sheets for tests click here

Column A in Page Registered → total 10 rows:

Arsenal de Sarandi
Palmeiras
Vasco
Flamengo
Goiás
Barcelona B
Almeria



Columns A,B in Page News using =FILTER(A1:A,ISNA(MATCH(A1:A,Registered!A1:A,0))) in B1. total 6 rows:

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

Arsenal De Sarandi           Barcelona
Palmeiras
Vasco
Flamengo
Goiás
Barcelona

Expected Result in Page News:

Arsenal De Sarandi           Arsenal De Sarandi
Palmeiras                    Barcelona
Vasco
Flamengo
Goiás
Barcelona

I tried:

=FILTER(A1:A,REGEXMATCH(Registered!A1:A,A1:A)=FALSE)

Error:

FILTER has mismatched range sizes. Expected Row Count: 6, Expected
Column Count: 1. Actual Row Count: 10, Actual Column Count: 1.

But when it has the same amount of rows, it’s still wrong because it finds Barcelona in Barcelona B, so the column of values only returns Arsenal De Sarandi.

So I tried:

=FILTER(A1:A,EXACT(Registered!A1:A,A1:A)=FALSE)

Error:

FILTER has mismatched range sizes. Expected Row Count: 6, Expected
Column Count: 1. Actual Row Count: 10, Actual Column Count: 1.

How to perfectly convert the FILTER ISNA MATCH to case sensitive without worrying about different sizes of total lines?

>Solution :

try:

=FILTER(A1:A, REGEXMATCH(A1:A, TEXTJOIN("|", 1, Registered!A1:A))=FALSE)
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading