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.

Try Data>Autofilter

Cheers,
--
AP

"Bunson" <[email protected]> a écrit dans le message de news:
[email protected]...
>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.

You can use programming to filter a table when the cell is changed.
There are examples here:

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