How to populate part of a list
 

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

How to populate part of a list
 

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!

How to populate part of a list
 

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!