(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!

Consider using Data Filter Autofilter, and select "Yes" from the dropdown
arrow on column "A"..........otherwise, what you are asking for will require
VBA code.

Vaya con Dios,
Chuck, CABGx3



"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!

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!