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