Hi Charlie,

Consider using Excel's built in AutoFilter featu

Data | Autofilter

If you are not familiar with this feature, see Debra Dalgleish's tutorial
at:

http://www.contextures.com/xlautofilter01.html

---
Regards,
Norman


"Charlie" wrote in message
...
I have spreadsheet like

Name hit1 hit2 hit3 hit4
a 1 2 4 1
c 2 2 2 2
b 2 2 3 3
a 1 1 2 1
c 1 2 1 2
a 3 1 1 1
b 2 2 2 2

I want to see data as per my choice.For example , if i enter 'a' in one
cel
i should have result in below mentioned format

Name hit1 hit2 hit3 hit4
a 1 2 4 1
a 1 1 2 1
a 3 1 1 1

same way if i enter 'b' i could have result for 'b' name.
I would be thankful if you help me to cope up this query by using advance
function of excel(no pivot table).