My forumulas are show this now:
=R5C1+RC[-1]-RC[-2]
instead of the original:
(A5+A1+A2
It is showing it in relative terms as in:
RC[-1] is one column before the current position. I tried to look under help to change it back to normal but don't know how. plz help!
Go to Tools|Options and in the General tab uncheck "R1C1 reference style"
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
whooo hoo thanks!!! took you guys only 5 mins to solve this on this forum. took me forever to find it under help lol
You need to enable R1C1 formulas i got it to work then. The formula fills down automatically as its a table.
Hope this helps.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Might have helped, 7 years ago. Lol
"11-01-2007, 11:55 AM"
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.Originally Posted by Jacc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks