Multiple conditions in advanced filter do no seem to work

[marcvanderpeet12]

Guys,

I have the following condition for an advanced filter (zie Screenshot attachted).

I does not seem to work however. The record on row 7 has a value of 0,03198 which is NOT between 0,63 and 0,73.

Any thought on why this filter is not working fine? File is uploaded as well.

Cheers,
Marc
__________________________________________________________________

Mod edit : post moved to appropriate forum …​

 

[NARAYANK991]

Hi ,

I had mentioned the reason in your earlier thread.

Narayan

 

[NARAYANK991]

Hi ,

See this file.

Narayan

 

[Marc L]

Hi !​

Any thought on why this filter is not working fine?

Advanced filter is always working fine according to its criterias ‼
Bad result : so bad criterias ! Row #7 is the result of criterias second row …

You must avoid to create a duplicate thread and
post to the appropriate VBA forum !
​

 

[marcvanderpeet12]

@NARAYANK991 Sorry for duplicating but I thought this is about something else. Thing is that I think the multiple conditions are not working.

Check out this screenshot: I used an advanced filter which should fetch the values with instrumentalness BETWEEN 0,04 AND 0,44 but when I see the results (of fe instrumentalness) I see also values of 0,001 which are not bigger than 0,04. As criteria I use B2 : H4

See attached screenshot. Do you understand what I mean? And is there a solution for this.

 

[Marc L]

It's only your bad !
Your actual criterias means criterias row #1 OR criterias row #2 !

For AND criterias, you must set criterias on an unique row
as written in every tutorial all over the Web …
​

 

[NARAYANK991]

Hi ,

I uploaded a file thinking it would help.

Narayan

 

[Marc L]

A sample demonstration, after its execution,
Marc, just check criterias in range L5:M6 …​

Sub Demo()
    Blad1.[L5:M6].Value = [{"Speechiness","Speechiness";">0,63","<0,73"}]
    Blad2.[B2].CurrentRegion.AdvancedFilter xlFilterCopy, Blad1.[L5:M6], Blad1.[B6:H6]
End Sub

Do you like it ? So thanks to click on bottom right Like !

For those with dot as decimal separator, update criterias accordindly …
​

 

[marcvanderpeet12]

It's only your bad !
Your actual criterias means criterias row #1 OR criterias row #2 !

For AND criterias, you must set criterias on an unique row
as written in every tutorial all over the Web …
​

Hi ,

I uploaded a file thinking it would help.

Narayan

My apologies, i appreciated the effort! My bet

 

[Chihiro]

Here's the set up for AND condition instead of OR.

 

[NARAYANK991]

Hi ,

Actually I should apologise , since the file I uploaded also had the incorrect setup. Sorry.

Narayan

 

[Marc L]

Marc, as in your screenshot comma is the decimal separator,
to try workbook from Chihiro, you must replace dot by comma
in each criteria cell to make it working …

​