classification in column
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 use excel 2k (non-english). I edited this post in division "worksheet functions" but anyone didn't give me reply. Many thanks in anticipation Regards Mark |
All times are GMT +1. The time now is 02:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com