Excel data sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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