Microsoft Excel (2010) expert required to create complex formula

IN PROGRESS
Bids
15
Avg Bid (USD)
$54
Project Budget (USD)
$30 - $250

Project Description:
We have a simple Excel workbook that contains a list of students and scores. The scores are represented as an alpha character. One of the worksheets contains a look up table relating the alpha character to a numeric character.

For each of the columns (subjects) I need the average score calculated in the last cell with the letter converted to a number value. I.e. convert the alpha scores for each subject per student to numeric value, then render the average taken using the number of subjects as the averaging value.

Please only bid on this if you have previous detailed knowledge of Excel formula and VBA functions.

Project is urgent and will be awarded very quickly for immediate completion.

Skills required:
Excel
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 1 days
$ 30
in 0 days
$ 30
in 1 days
$ 30
in 0 days
$ 50
in 1 days
$ 30
in 1 days
$ 30
in 1 days
$ 40
in 2 days
Hire marcfloyd
$ 80
in 1 days
Hire isupportu
$ 30
in 0 days