Discussion Locked
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hi, Did an advanced filter in excel and working fine. Tried to set one of the criteria as any value between 70 to 90 for one of the column and not able to get it to work. Can set criteria to any value below 90 using <=90 and will work, but can figure how to set it for in between. Any advise?
5 replies
by dklippert
It's easy to do with an AutoFilter.
With an Advanced filter, you need an AND.
Let's say the name of the column is Stuff.
Set up your Criteria range with "Stuff" as the heading in two adjacent cells. Below one put >=70 and <=90 below the other.
by sebastianchu
The question was auto-closed by TechRepublic
by sebastianchu
Hi,
thanks for your answer, it solved my problems
thanks once again
sebastian
by sebastianchu
The question was auto-closed by TechRepublic
by sebastianchu
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies