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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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
All Courses

From novice to tech pro — start learning today.