M
Mark
Hi,
I looking for verified function in column "Classification":
Name1 Name2 Score Classification (wich function??)
1 A 15,5 1 .. of 1(Name1)and A(Name2)
0 A 14,2 1 .. of 0(Name1)and A(Name2)
1 A 14,3 2 .. of 1(Name1)and A(Name2)
1 B 14,4
0 B 16,1
0 A 13,1 2 .. of 0(Name1)and A(Name2)
1 A 12,1
1 A 12,6 3 .. of 1(Name1)and A(Name2)
and more records with minimum Score....
Function should count place on basis of best Score.
I want for a start classification for:
-best score for A(column2) and 1(column1),
-best score for A(column2) and 0(column1),
Quantity places is conditional on quantity A (column2)
with 1 or 0 (column1). In this example base for all is 1:4
so 25% A with 1 and A with 0 have place and award.
I'd like function not VBA.
Many thanks in anticipation
Regards
Mark
I looking for verified function in column "Classification":
Name1 Name2 Score Classification (wich function??)
1 A 15,5 1 .. of 1(Name1)and A(Name2)
0 A 14,2 1 .. of 0(Name1)and A(Name2)
1 A 14,3 2 .. of 1(Name1)and A(Name2)
1 B 14,4
0 B 16,1
0 A 13,1 2 .. of 0(Name1)and A(Name2)
1 A 12,1
1 A 12,6 3 .. of 1(Name1)and A(Name2)
and more records with minimum Score....
Function should count place on basis of best Score.
I want for a start classification for:
-best score for A(column2) and 1(column1),
-best score for A(column2) and 0(column1),
Quantity places is conditional on quantity A (column2)
with 1 or 0 (column1). In this example base for all is 1:4
so 25% A with 1 and A with 0 have place and award.
I'd like function not VBA.
Many thanks in anticipation
Regards
Mark