issue with code

I ma having a problem with the word scrape because the position 1 comes up twice.  This will make no sense without the attached file.  Look at the word and the logic of assigning points to word parts.  The issue is that the 'scr' part of the word is assigned two points because it comes up under two headings but the code sees this as an error.
spelling-marker-03.xls
Dier02Asked:
Who is Participating?
 
RunriggerConnect With a Mentor Commented:
I think that is due to the position value in column U being 1, it should be 5, same with resident, value in U should be 4!
0
 
StephenJRCommented:
Why don't you explain what you are doing and your precise problem rather than expecting us to figure it all out?
0
 
patrickabCommented:
Dier02,

>The issue is that the 'scr' part of the word is assigned two points because it comes up under two headings but the code sees this as an error.

It doesn't show up as an error when I looked at it a minute ago. Can't see a problem with it. However I'm not at all sure why scr merits two lots of points instead of only one set of points.

Patrick
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
RunriggerCommented:
looks like your formula are pointing to the wrong cells, see attached, I think that I have corrected them;


ee-spelling-marker-03.xls
0
 
Dier02Author Commented:
Runrigger - what about the word discovery - it has three points - one for the 'dis' one for the 'y' and one for the correct spelling but it is only showing 2 marks?
Patrick - its because it comes up under two headings so a point for each - but I think the problem was that the 'scr' occupied the 1st position so it wouldn't give a mark for each position - only one?
0
 
Dier02Author Commented:
In other words it saw the scr and 1 only once and saw the second entry as an error?
0
 
Dier02Author Commented:
'trapped' should be four points and it is coming up three as well.  I can;t see why.
0
 
RunriggerCommented:
My fault, got the second formula wrong!
ee-spelling-marker-03.xls
0
 
RunriggerCommented:
trapped looks OK now too in the above file
0
 
Dier02Author Commented:
Looking good. Confidence should be 5 but is showing 4???
0
 
Dier02Author Commented:
E9 for confidence should show i as position 5 (my bad)
0
 
Dier02Author Commented:
You are correct!
0
 
Dier02Author Commented:
I also just worked out that I needed to click save to see the changes!
0
 
Dier02Author Commented:
Great work.  Thank you!
0
 
RunriggerCommented:
You are welcome, and thank you for the grading.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.