software

How do I find all rows in a range that contain a particular value in one
column and another value in a different column? e.g. Find all rows where
column B = quot;applequot; and column C = quot;piequot;.

What do you mean by 'find' ?
To count them use =SUMPRODUCT(--(B1:B100=quot;applequot;),--(C1:C100=quot;piequot;))
To display them in some color use Format Conditional Formatting with Formula
IS
=AND(B1=quot;applequot;, C1=quot;piequot;)
best wishes - please come back is more is needed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;wmclemorequot; gt; wrote in message
...
gt; How do I find all rows in a range that contain a particular value in one
gt; column and another value in a different column? e.g. Find all rows where
gt; column B = quot;applequot; and column C = quot;piequot;.
Use an Auto Filter on the top line of your spreadsheet, where all your
headers sit. (under Data - Filter - Auto Filter). Then using the drop down
box of the data filter for column B, select quot;(custom)quot;. Select Equals as you
where condition and in the value area type quot;applequot;. Select OK and this should
have narrowed down the displayed data in column B to those row containing
quot;applequot;.

Do the same for column C, i.e. use the drop down box of the data filter for
column C, select quot;(custom)quot;. Select Equals as you where condition and in the
value area type quot;piequot;. Select OK and this should have narrowed down the
displayed data in column C to those row containing quot;piequot;.

Now you should only be looking at rows that have apple in column B and pie
in column C.

quot;wmclemorequot; wrote:

gt; How do I find all rows in a range that contain a particular value in one
gt; column and another value in a different column? e.g. Find all rows where
gt; column B = quot;applequot; and column C = quot;piequot;.

This is great, Bernard! As I evaluated the formula, I could not tell what
the two quot;--quot;s were accomplishing. Nor could I find quot;--quot; in the help. What
does quot;--quot; accomplish?

Thanks,
William

quot;Bernard Liengmequot; wrote:

gt; What do you mean by 'find' ?
gt; To count them use =SUMPRODUCT(--(B1:B100=quot;applequot;),--(C1:C100=quot;piequot;))
gt; To display them in some color use Format Conditional Formatting with Formula
gt; IS
gt; =AND(B1=quot;applequot;, C1=quot;piequot;)
gt; best wishes - please come back is more is needed
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;wmclemorequot; gt; wrote in message
gt; ...
gt; gt; How do I find all rows in a range that contain a particular value in one
gt; gt; column and another value in a different column? e.g. Find all rows where
gt; gt; column B = quot;applequot; and column C = quot;piequot;.
gt;
gt;
gt;

Glad it worked.
For SUMPRODUCT see
www.xldynamic.com/source/xld.SUMPRODUCT.html

and this explains the quot;--quot;:
mcgimpsey.com/excel/formulae/doubleneg.html

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;wmclemorequot; gt; wrote in message
...
gt; This is great, Bernard! As I evaluated the formula, I could not tell what
gt; the two quot;--quot;s were accomplishing. Nor could I find quot;--quot; in the help.
gt; What
gt; does quot;--quot; accomplish?
gt;
gt; Thanks,
gt; William
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; What do you mean by 'find' ?
gt;gt; To count them use =SUMPRODUCT(--(B1:B100=quot;applequot;),--(C1:C100=quot;piequot;))
gt;gt; To display them in some color use Format Conditional Formatting with
gt;gt; Formula
gt;gt; IS
gt;gt; =AND(B1=quot;applequot;, C1=quot;piequot;)
gt;gt; best wishes - please come back is more is needed
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;wmclemorequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; How do I find all rows in a range that contain a particular value in
gt;gt; gt; one
gt;gt; gt; column and another value in a different column? e.g. Find all rows
gt;gt; gt; where
gt;gt; gt; column B = quot;applequot; and column C = quot;piequot;.
gt;gt;
gt;gt;
gt;gt;