Need help in Defining Criteria for Range

M

malikmudassar

Joined
Dec 15, 2013
Messages
2
Reaction score
0
I have a table with a field class with possible values 1st, 2nd , 3rd , 4th. I want to create an advance filter criteria for my range that can filter values based on class column for 1st and 2nd only

I tried;

=("="&"1st") This works for only 1st
But if I try to add another in OR like

=OR("="&"1st","="&"2nd") it doesn't work

Can anyone help?
 
Never Mind!

I fixed it, for those who have no idea, This is what i did.

To use OR condition while defining a criteria range , Conditions should be entered on separate lines

My Criteria cell title was Class and This is how i did it

Class
=("="&"1st")
=("="&"2nd")

This worked for me to filter the range for both classes 1st and 2nd
 
Back
Top