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!