Excel data sorting
 

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).

Excel data sorting
 

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).