Suitable formula in excel

[jkreza2008]

Hi All,
I need help on the following problem.

I have a series of values, for example:
20
30
40
50
60

which appear in various cells, each of which representing a value across a timeline.
So it could be that X scores
60% in Grade 1,
55% in Grade 2,
67% in Grade 3,
72% in Grade 4,
45% in Grade 5,
36% in Grade 6,
72% in Grade 7,
86% in Grade 8,
42% in Grade 9, and
67% in Grade 10

If I want the values to be returned into a specific cell with a progression in time (Grade1, Grade 2 ...), what would be the best way forward?

Best regards,
Jason

 

[gsbelbin]

Sorry but I can't understand what you are after. Could you give a bit more explanation and possibly an example of the data along with your expected output.