View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stewart[_3_] Stewart[_3_] is offline
external usenet poster
 
Posts: 8
Default Finding closest value within an array

I've got some results which I need to grade against some
benchmarks e.g.
A=90% and above
B=80% and above
C=70% and above

I've got 10000 pupils with varying results is there any
macro I can create to give each pupil a grade for their
result and put it on a worksheet (I would use formulas but
that makes the workbook way too big - as I have to repeat
this for 18 subjects!)

Thank you for any help you can give.

Stewart