excel filter formula

[Guest]

I have a spreadsheet set up with: Assignment - User Name - then 25 other
columns named with different modules. The 25 columns will either have a "Y"
or "N" in them.
I want to pull out all the users with Assignments in Booking, then I want
to pull out all the "Y" columns that match. So if one user in Booking has a
"N" is one of the columns that user will not show.
Is there a formula that will do this, or would queries in access work better
if I import into Access. I'm not sure. Auto Filter does not work, I need
something where I can pull it into another sheet, and the copy and paste
would take to long for the different areas I need to search on. Thanks,

 

[Guest]

If your data is set up in a table you can either import into Access and run
queries off that or else, you can use the MS Query tool (Data--Get External
Data) to convert your table of data into a pseudo-database off which you can
build a SQL query, or else you can likely use XL formulas to extract the
relevant data.

Another thought would be the Advanced Filter tool. See here for ideas:
http://www.contextures.com/xladvfilter01.html

Dave