If you put this formula in D2:

=IF(B2<C2,"Yes","No")

and copy down, then you can apply autofilter to column D and select
"Yes" from the filter pull-down.

Hope this helps.

Pete

On Jul 11, 6:54*pm, Satya Nanduri
wrote:
I use Excel 2003. *I am doing a detailed analysis to make a "make or buy"
decision. *I have a table containing columns QUANTITIES - BUYING COST -
MAKING COST. *Data run into sevaral rows according to buying quantites and
related costs. *I need to find out the "QUANTIES WHERE BUYING COST IS LOWER
THAN MAKING COST" to help my boss to decide at what quanties it is economical
to start buying. *

I tried VLOOKUP / HLOOKUP /IF etc. *nothing worked. *I will be grateful if
any body help me to solve this problem? *

Satya Nanduri