Hi Jessica,

Am Tue, 28 Oct 2014 09:38:15 -0700 (PDT) schrieb Jessica Wiley Oaks:

I have an excel spreadsheet with client ID#s and varying criteria in each column header. If they meet "yes" criteria in 5 of the column headers how do get I get those specific client ID#s to show up in a new sheet? Is there a formula? I've been doing some research on vlookup. I know some java programming with if, else if statements but not sure how to apply it to excel.

filter these 5 columns by "Yes"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional