Filtering by criteria in two columns

I'm new to the advanced features of 2003 and I'm having a problem getting a
spreadsheet to filter correctly. I need to filter based on the criteria that
a value in one column is equal to "value A" or a value in another column is
equal to "value B". Any help would be greatly appreciated. Thanks.

Mike

I think that you would need to create a helper column that makes those two
test returning True or false, and filter by that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bookmike" <[email protected]> wrote in message
news:[email protected]...
> I'm new to the advanced features of 2003 and I'm having a problem getting
a
> spreadsheet to filter correctly. I need to filter based on the criteria
that
> a value in one column is equal to "value A" or a value in another column
is
> equal to "value B". Any help would be greatly appreciated. Thanks.
>
> Mike

I think that you would need to create a helper column that makes those two
test returning True or false, and filter by that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bookmike" <[email protected]> wrote in message
news:[email protected]...
> I'm new to the advanced features of 2003 and I'm having a problem getting
a
> spreadsheet to filter correctly. I need to filter based on the criteria
that
> a value in one column is equal to "value A" or a value in another column
is
> equal to "value B". Any help would be greatly appreciated. Thanks.
>
> Mike

Would the auto 'drop down' filter by column work?
I filter multiple columns at work by one filter at a time, depending on the
relevancy of the data needed.

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> I think that you would need to create a helper column that makes those two
> test returning True or false, and filter by that column.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bookmike" <[email protected]> wrote in message
> news:[email protected]...
> > I'm new to the advanced features of 2003 and I'm having a problem
getting
> a
> > spreadsheet to filter correctly. I need to filter based on the criteria
> that
> > a value in one column is equal to "value A" or a value in another column
> is
> > equal to "value B". Any help would be greatly appreciated. Thanks.
> >
> > Mike
>
>

Would the auto 'drop down' filter by column work?
I filter multiple columns at work by one filter at a time, depending on the
relevancy of the data needed.

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> I think that you would need to create a helper column that makes those two
> test returning True or false, and filter by that column.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bookmike" <[email protected]> wrote in message
> news:[email protected]...
> > I'm new to the advanced features of 2003 and I'm having a problem
getting
> a
> > spreadsheet to filter correctly. I need to filter based on the criteria
> that
> > a value in one column is equal to "value A" or a value in another column
> is
> > equal to "value B". Any help would be greatly appreciated. Thanks.
> >
> > Mike
>
>

Would the auto 'drop down' filter by column work?
I filter multiple columns at work by one filter at a time, depending on the
relevancy of the data needed.

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> I think that you would need to create a helper column that makes those two
> test returning True or false, and filter by that column.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bookmike" <[email protected]> wrote in message
> news:[email protected]...
> > I'm new to the advanced features of 2003 and I'm having a problem
getting
> a
> > spreadsheet to filter correctly. I need to filter based on the criteria
> that
> > a value in one column is equal to "value A" or a value in another column
> is
> > equal to "value B". Any help would be greatly appreciated. Thanks.
> >
> > Mike
>
>

Would the auto 'drop down' filter by column work?
I filter multiple columns at work by one filter at a time, depending on the
relevancy of the data needed.

"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> I think that you would need to create a helper column that makes those two
> test returning True or false, and filter by that column.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "bookmike" <[email protected]> wrote in message
> news:[email protected]...
> > I'm new to the advanced features of 2003 and I'm having a problem
getting
> a
> > spreadsheet to filter correctly. I need to filter based on the criteria
> that
> > a value in one column is equal to "value A" or a value in another column
> is
> > equal to "value B". Any help would be greatly appreciated. Thanks.
> >
> > Mike
>
>

I think that you would need to create a helper column that makes those two
test returning True or false, and filter by that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bookmike" <[email protected]> wrote in message
news:[email protected]...
> I'm new to the advanced features of 2003 and I'm having a problem getting
a
> spreadsheet to filter correctly. I need to filter based on the criteria
that
> a value in one column is equal to "value A" or a value in another column
is
> equal to "value B". Any help would be greatly appreciated. Thanks.
>
> Mike

I think that you would need to create a helper column that makes those two
test returning True or false, and filter by that column.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"bookmike" <[email protected]> wrote in message
news:[email protected]...
> I'm new to the advanced features of 2003 and I'm having a problem getting
a
> spreadsheet to filter correctly. I need to filter based on the criteria
that
> a value in one column is equal to "value A" or a value in another column
is
> equal to "value B". Any help would be greatly appreciated. Thanks.
>
> Mike