Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A formula to auto-update a classification ONLY if it goes UP | Excel Worksheet Functions | |||
ABC Inventory Classification | Excel Worksheet Functions | |||
Problem formating cells Weine Classification Scheme for library la | Excel Worksheet Functions | |||
Insert Row (Event Classification) | Excel Discussion (Misc queries) | |||
Change Font Color Based on Classification | Excel Discussion (Misc queries) |