View Single Post

ahajv4life · 02-05-2008, 01:40 AM

Sorry, I just copy/pasted this from my answers.yahoo board....

I need a list/drop list, but I haven't been able to find the answer.
say in my first column, it goes down 100 rows, and in those rows are numbers 1-10 randomly. I need to make drop down list(?) at the top of the column that I can select any of those 1-10 numbers, and by doing so, will bring up only the rows that have the selected number.

Say I click the drop list, and click number 5. Then, only the rows that have the number 5 are show, until I click on the drop list again, and pick another number (we will say 3), and then only the rows with the number 3 are shown.

Ideas

Additional Details

3 minutes ago
Also, if in the list, nothing is selected, then all the row, regardless of what is in them, shows up.

02-05-2008, 01:40 AM	#1 (permalink)
ahajv4life Platinum Member Join Date: Aug 2004 Location: Minnesota Age: 24 Posts: 730	MS Excel Sorry, I just copy/pasted this from my answers.yahoo board.... I need a list/drop list, but I haven't been able to find the answer. say in my first column, it goes down 100 rows, and in those rows are numbers 1-10 randomly. I need to make drop down list(?) at the top of the column that I can select any of those 1-10 numbers, and by doing so, will bring up only the rows that have the selected number. Say I click the drop list, and click number 5. Then, only the rows that have the number 5 are show, until I click on the drop list again, and pick another number (we will say 3), and then only the rows with the number 3 are shown. Ideas Additional Details 3 minutes ago Also, if in the list, nothing is selected, then all the row, regardless of what is in them, shows up.