Software

Ask something
Discussion Locked

Excel Software

0 helpful
5 replies

by sebastianchu

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.

This discussion is closed to new replies.