Robert_Kroschel
New Member
- Joined
- Mar 28, 2018
- Messages
- 8
I've been kicking this one around for a long time now. I would like to assign a numeric value to a cell based on its position in a table or row.
I would then like to total the value of each respective cell content.
Ignore Columns H - RS3
A number will be placed in the first column S1 I would like to assign it the highest value rate of 1
Another number will be placed in S2 and I would like to assign a value rate of 0.5
And another number will be placed in Column S3 and it will be assigned a rate value of .25
The same Pattern applies for Cells RS1 - RS3 and also R1-R3.
I then want to count the number that appears the most amount of times while also totalling its overall rating from the three column groups
Now considering all the other columns lets say the no 16 appears 5 times across the entire row, its count is 5 but its value is dependant on where it appeared in the three main column groups
So if 16 was first in column group S it is assigned a value of 1 then further more 16 appeared in the second column In the RS column group it would be assigned a value of 0.5 (totalling 1.5 at this point) if the no 16 appeared in the 1st column of the R Group it would be assigned a value of 1. (totalling 2.5)
The value 16 is an arbitrary value so hence could be text I suppose. It is not a fixed value.
So in this example 16 would end up with count value of 5 and rating value of 2.5
I hope someone can help me with this challenge
.
I would then like to total the value of each respective cell content.
Ignore Columns H - RS3
A number will be placed in the first column S1 I would like to assign it the highest value rate of 1
Another number will be placed in S2 and I would like to assign a value rate of 0.5
And another number will be placed in Column S3 and it will be assigned a rate value of .25
The same Pattern applies for Cells RS1 - RS3 and also R1-R3.
I then want to count the number that appears the most amount of times while also totalling its overall rating from the three column groups
Now considering all the other columns lets say the no 16 appears 5 times across the entire row, its count is 5 but its value is dependant on where it appeared in the three main column groups
So if 16 was first in column group S it is assigned a value of 1 then further more 16 appeared in the second column In the RS column group it would be assigned a value of 0.5 (totalling 1.5 at this point) if the no 16 appeared in the 1st column of the R Group it would be assigned a value of 1. (totalling 2.5)
The value 16 is an arbitrary value so hence could be text I suppose. It is not a fixed value.
So in this example 16 would end up with count value of 5 and rating value of 2.5
I hope someone can help me with this challenge
.