**Question description:**

*This user has given permission to use the problem statement for this blog.*

how do I do the same formula for different cells, but i want a different cells value in each of the formulas. For example, if i was trying to find the percentage grade of each student in a class of 300.

Solved by I. W. in 14 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
14/09/2017 - 08:27

I believe thats it

Excelchat Expert
14/09/2017 - 08:28

Okay, great.

Excelchat Expert
14/09/2017 - 08:28

Can you explain what you are looking for in more detail.

User
14/09/2017 - 08:28

I can type out an example in the excel sheet if you would like

Excelchat Expert
14/09/2017 - 08:28

That would be perfect! Thank you.

User
14/09/2017 - 08:29

say this is five students

User
14/09/2017 - 08:29

i want to take the percentage of each students grade and post it beside it

User
14/09/2017 - 08:29

But i have over 300 students so i do not want to do it one at a time

Excelchat Expert
14/09/2017 - 08:29

Okay, This is simple for you.

User
14/09/2017 - 08:29

what formula would i use if i wanted to do them all at one time

Excelchat Expert
14/09/2017 - 08:29

Entering Explanation phase.

Excelchat Expert
14/09/2017 - 08:30

We will create an absolute reference to E1. Then copy a simple percentage formula down.

Excelchat Expert
14/09/2017 - 08:30

=B2/$E$1

Excelchat Expert
14/09/2017 - 08:31

The "$" locks the cell

Excelchat Expert
14/09/2017 - 08:31

So $E locks column E

Excelchat Expert
14/09/2017 - 08:31

and $1 locks row 1.

Excelchat Expert
14/09/2017 - 08:31

So $E$1 locks cell E1.

Excelchat Expert
14/09/2017 - 08:32

Entering Discussion Phase

Excelchat Expert
14/09/2017 - 08:32

Let me know if you have any questions about the solution.

User
14/09/2017 - 08:32

After B2 would i just drag down through the column

Excelchat Expert
14/09/2017 - 08:32

Yes.

Excelchat Expert
14/09/2017 - 08:32

I have a quicker way though.

Excelchat Expert
14/09/2017 - 08:32

Click in C2 and copy.

Excelchat Expert
14/09/2017 - 08:33

then go to C3 Click and then press cntrl+shft+down arrow and select the entire sheet. Then paste.

Excelchat Expert
14/09/2017 - 08:34

Select the entire column down from C3*

User
14/09/2017 - 08:34

Perfect. My boss asked me to create a LOOKUP table so i may be coming back for more help because I am relatively new to excel.

User
14/09/2017 - 08:34

VLOOKUP*

Excelchat Expert
14/09/2017 - 08:34

We can help with that as well.

Excelchat Expert
14/09/2017 - 08:34

Have you heard of the new subscription version of Excel? You can keep using your existing computer/laptop and get latest features automatically like online file sharing, and even a browser version of Excel that work with your files. I like it.

Excelchat Expert
14/09/2017 - 08:34

You should try it. It doesn’t cost much. It’s called Office 365 Business.

User
14/09/2017 - 08:35

If i uploaded a file could you help me real quick?

Excelchat Expert
14/09/2017 - 08:36

I'm sorry, I'd love to help, but it is unfortunately against company policy and I could be disciplined if I breached contract.

User
14/09/2017 - 08:36

Understandable. Could i just join another session and receive help from it?

Excelchat Expert
14/09/2017 - 08:37

Yes.

User
14/09/2017 - 08:37

It may be against company policy again, but could i specifically request you for help?

Excelchat Expert
14/09/2017 - 08:38

Yes, you can, but another expert may still claim the question.

User
14/09/2017 - 08:38

Oh okay. Thank you for your help

Excelchat Expert
14/09/2017 - 08:38

You're very welcome. Just specify that'd you want to work with the same expert as before.

User
14/09/2017 - 08:39

Will do. If i do not have an account registered they will still be able to tell who i worked with before because of my IP address right?

Excelchat Expert
14/09/2017 - 08:40

The other experts don't see that information. We all work remotely and compete for sessions.

Excelchat Expert
14/09/2017 - 08:40

Some may avoid claiming because of your mention of previous expert though

User
14/09/2017 - 08:41

Well a question will appear at exactly X:45. which is in 4 minutes and it will have a question about a VLOOKUP table. If you see the question thats me haha

Excelchat Expert
14/09/2017 - 08:42

okay, i'll keep an eye out thank you.

Excelchat Expert
14/09/2017 - 08:42

:)

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*