Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Column drop-down list sorter
I need to create a drop-down memu in the column headers that show only rows
with corresponding list info. So, I have a column title Names, I have 10 rows of data and under the column Names, I have Nancy, Katie and Mary. I need to be able to select only Mary and all the other rows that have Nancy and Katie in that column are not shown. Does that make sense? and how do I do it? |
#2
|
|||
|
|||
Use the Autofilter feature.
http://www.officearticles.com/excel/...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "CMonroe329" wrote in message ... I need to create a drop-down memu in the column headers that show only rows with corresponding list info. So, I have a column title Names, I have 10 rows of data and under the column Names, I have Nancy, Katie and Mary. I need to be able to select only Mary and all the other rows that have Nancy and Katie in that column are not shown. Does that make sense? and how do I do it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
circular drop down list on different pages | Excel Worksheet Functions | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
match and count words | Excel Worksheet Functions | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |