Forum Discussion

Copper Contributor

May 01, 2018

Making a script

Hello! I need some assistance. I am working on making a scripted set of columns for work. Lets say the scripts take up individual cells from A3 to A7. I am trying to find a formula where I can put an...

excel

Excel Online

Formulas and Functions

madhukar jadhav

Copper Contributor

Oct 15, 2018

i would like to code for following data in worksheet "Data" with scripting dictionary, where no. of students may increase.Also ouput the dictonary data to other worksheet "Output".

| Name   | maths | science | lang | history |
|--------|-------|---------|------|---------|
| pandit | 78    | 78      | 57   | 67      |
| sushil | 44    | 70      | 67   | 79      |
| kiran  | 48    | 55      | 57   | 67      |
| manoj  | 78    | 79      | 67   | 69      |
| kumar  | 78    | 52      | 80   | 74      |
| ranjit | 56    | 61      | 63   | 57      |

thanks