Filter multiple columns

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

If you are filtering on the ID, then why would you need to filter on any other field. Is not the ID unique?

Maybe something like this:

Formula:

Please Login or Register  to view this content.

Hi Malagon,

Try this formula in B5.

Formula:

Please Login or Register  to view this content.

You have been given two formulae. One filters on the last and first names, and the second on just the last name (in cell D2).

I¿m not sure what you are trying to achieve. You have only one cell, D2, for the search value (last name). For my suggestion, I selected E2 for the first name.

How do you want to filter on all of those fields? Do you want to make cell B2 a drop down where you choose the filter, and then D2 contains the search parameter?

You could, for example, use this:

Formula:

Please Login or Register  to view this content.

Change B2 to "Search Department" (no quotes) and D2 to "IT Services". You could perhaps use Data Validation to complete both input cells.

Please Login or Register  to view this content.

Please see the updated sample file and see if it does what you want.

I have added a Reference sheet that extracts the headers for the primary drop down list and unique lists for each of the columns.

If you change the primary input cell, Conditional Formatting will highlight the secondary input cell as a prompt to select a valid entry.

Select cell D2. Choose Data | Data Validition. Select the Error Alert tab. Change Style to Warning or Information. OK out.

You're welcome.


Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

You know, you don't have to put your text in tags

Thanks for the rep.