I have tried methods that i know, but it doesn't work, so i hope there is an expert with this who can help me out with this bit!
ok, i got two column with these data:
Round Pos
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 10
1 Incompleted
1 Incompleted
1 Incompleted
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 Incompleted
2 Incompleted
2 Incompleted
I want the number of ppl with a Position (mean every1 except those who incompleted it). for round both round 1 and 2.
So the experted result is :
Round 1 10 ppl finished it
Round 2 8 ppl finished it
but of course i need to do this excel, can anyone pls teach me how i can do this please?
please help
ok, i got two column with these data:
Round Pos
1 1
1 2
1 3
1 4
1 5
1 6
1 7
1 8
1 9
1 10
1 Incompleted
1 Incompleted
1 Incompleted
2 1
2 2
2 3
2 4
2 5
2 6
2 7
2 8
2 Incompleted
2 Incompleted
2 Incompleted
I want the number of ppl with a Position (mean every1 except those who incompleted it). for round both round 1 and 2.
So the experted result is :
Round 1 10 ppl finished it
Round 2 8 ppl finished it
but of course i need to do this excel, can anyone pls teach me how i can do this please?
please help