Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Good day all

I have a table on a worksheet with two columns (name/ID). each column has a drop downlist data. I want to filter one column by using other drop down list.

for example when I choose a name from list in the column (name) must the other column filterd to match the selection.

Best regards,

share|improve this question

migrated from Nov 17 '11 at 11:41

This question came from our site for professional and enthusiast programmers.

What is your Excel's Version ?

You have to select the Column Headers and click on "Data", "Filter" and "automatic filter" for XL2003 "Data", "Filter" for XL2007 and probably 2010.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.