Filter a table with an OR logic based on columns values

**AceX** · 02-10-2010, 11:28 AM

Hi

i have a table and have some columns.

i want to filter the table so that i just see the records which have "text1" in ther column "F" OR they have "text2" in ther column "H", for example.

How can i implement an OR filter ?

thanks in advance.

**martindwilson** · 02-10-2010, 11:41 AM

use advanced filter put the same column headings for f an h in another 2 columns .say j1 and k1
then in j2 put text1 in k3 put text2
filter advanced filter
on columns f and h
criteria range =$j$1:$k$3

**AceX** · 02-11-2010, 03:12 AM

Thanks !

i don't know why, but i searched before i post this topic and i tried this before, may be i did sth wrong because it did not work,

and now it works !

thanks again,
and Solved

Filter a table with an OR logic based on columns values

LinkBack

Thread Tools

Rate This Thread

Display

Filter a table with an OR logic based on columns values

Re: Filter a table with an OR logic based on columns values

Re: Filter a table with an OR logic based on columns values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions