Hi,

Refer to the following URL: http://www.contextures.com/xlDataVal02.html

or Enter the folllowing in the Google Search: Peltier Technical Service, Inc.

Challa Prabhu

"dj479794" wrote:

(Excel 2003)

Data:

Column A: Values are either "YES" or "NO"
Column B: Text Field (Ex: Soccer, Football, Baseball....)
Column C: Number field ( Ex: 1.5, 0.5, 2.5, 1.0....)

I want to list in Column E and F The values of Column B & C only if Column
A is "YES". (Without blank rows inbetween)

Please Help! Thanks!