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