P
Peter
I have a worksheet that captures auditing errors:
[A] [C] [D] [E] [F]
1 [name] [course] [Course cost] [3.1] [3.2] [6.7]
second worksheet
[A ]
1 25% 3.1
2 50% 3.2
3 80% 6.7
and so forth the values are in separate cells so each person can have
multiple errors.
another worksheet contains a column with he errors and another column next
to it with the funding value of each error ranging from 25% to 100%.
What I want to do is get the highest (max) value of percentage error so if
3.1 were 25%, 3.2 50% and 6.7 80% (as per example above) I want it to return
80% that way I can take the course cost for that learner and work out the
value of the error. so if course cost £150 then I would take 80% of 150.
I am not sure how to work out the lookup to get the max value from the row
of error codes.
hope I have explained myself
regards
Peter
[A] [C] [D] [E] [F]
1 [name] [course] [Course cost] [3.1] [3.2] [6.7]
second worksheet
[A ]
1 25% 3.1
2 50% 3.2
3 80% 6.7
and so forth the values are in separate cells so each person can have
multiple errors.
another worksheet contains a column with he errors and another column next
to it with the funding value of each error ranging from 25% to 100%.
What I want to do is get the highest (max) value of percentage error so if
3.1 were 25%, 3.2 50% and 6.7 80% (as per example above) I want it to return
80% that way I can take the course cost for that learner and work out the
value of the error. so if course cost £150 then I would take 80% of 150.
I am not sure how to work out the lookup to get the max value from the row
of error codes.
hope I have explained myself
regards
Peter