Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter data automatically by input
I am looking for some way to filter datas automatically based on user's input
in a dedicated cell. For example, I got a list of values like below. Value 1 2 3 3 4 4 If user input 3 in a cell and press enter, those rows with value equals to 3 will be displayed. All other rows will be hidden. Can I have a function like this by using excel formula/function? Thanks everbody. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter data automatically by input
Try DataAutofilter
Cheers, -- AP "Bunson" a écrit dans le message de news: ... I am looking for some way to filter datas automatically based on user's input in a dedicated cell. For example, I got a list of values like below. Value 1 2 3 3 4 4 If user input 3 in a cell and press enter, those rows with value equals to 3 will be displayed. All other rows will be hidden. Can I have a function like this by using excel formula/function? Thanks everbody. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter data automatically by input
You can use programming to filter a table when the cell is changed.
There are examples he http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Week Number' Bunson wrote: I am looking for some way to filter datas automatically based on user's input in a dedicated cell. For example, I got a list of values like below. Value 1 2 3 3 4 4 If user input 3 in a cell and press enter, those rows with value equals to 3 will be displayed. All other rows will be hidden. Can I have a function like this by using excel formula/function? Thanks everbody. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Valitaion Input message | Excel Worksheet Functions | |||
Clear"Reset" data input. | Excel Worksheet Functions | |||
***Two Input Data Tables*** | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Multiple worksheet queries | Excel Worksheet Functions |