How to populate part of a list

[Guest]

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

 

[Guest]

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

 

[Guest]

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