Hi,
Can someone help me how can i class a set of data (probably 6 column) into 3 class range using excel function?
For example:
Class Range :
Class I : 81-100
Class II : 60-80
Class III : 0-59
I can't do by row because each row have different target row and class. I have 1000++ of rows.
Can someone help me how can i class a set of data (probably 6 column) into 3 class range using excel function?
For example:
DO INDEX INDEX | BOD INDEX INDEX | COD INDEX INDEX | SS INDEX | pH Index | AN INDEX |
44 | 79 | 69 | 51 | 29 | 31 |
27 | 88 | 72 | 57 | 99 | 5 |
28 | 77 | 60 | 56 | 98 | 56 |
14 | 73 | 73 | 80 | 74 | 32 |
45 | 92 | 72 | 95 | 86 | 26 |
59 | 92 | 88 | 55 | 37 | 65 |
25 | 61 | 44 | 55 | 93 | 28 |
36 | 73 | 53 | 71 | 98 | 0 |
23 | 77 | 61 | 59 | 96 | 61 |
84 | 17 | 18 | 78 | 90 | 38 |
Class Range :
Class I : 81-100
Class II : 60-80
Class III : 0-59
I can't do by row because each row have different target row and class. I have 1000++ of rows.