1) Click on row 1 where your titles are
2) Select DATA FILTER AUTOFILTER to activate the autofilter
3) Now use the drop down in the "name" column to select "x"

You should be looking at a filtered list. The rest is hidden.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Durai" wrote:

I like to use a dropdown button to see data related to a row name.
Example
name item# amount
x ac 100
x ab 200
v aa 300
v ax 150
x ac 800
c bd 200
x cd 150
how can i use a dropdowm button inorder to see the details for name "x' only.
Any help Please