LinkBack URL
About LinkBacks
Hello all,
Brand new rookie to Excel, never used it to do anything other than chart data before. I have a list of data entries that I need to have divided by a large number and get the individual outputs. How do I do this? Please be gentle.
Hello all,
Brand new rookie to Excel, never used it to do anything other than chart data before. I have a list of data entries that I need to have divided by a large number and get the individual outputs. How do I do this? Please be gentle.
Assuming you data is in A column then try
B1
Formula:
Please Login or Register to view this content.
and drag down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi, welcome to the forum
Your question is a little vague
Do you mean you have a bunch of cells in a column, and you want to divide each 1 by a constant value - and have that answer appear in another cell?
or...................?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I don't think I explained myself very well. I have a list of data points from A2-A37. I want to divide each and every one of those points by a separate, unrelated integer value and return an answer for every data point in a different list, ie. C2-C37. I don't know how to do that.
Maybe this?
C2=A2/your-number
copied down
Instead of hard-coding your-number, you could put in it's own cell and then reference it - that will make it easy to change your-number, if you need to...
=A2/$D$2
where D2 contains your-number. Note the use of $ there, that "locks" the cell so it wont adjust as you copy it down
That did the trick, thanks a plenty for the help!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks