LinkBack URL
About LinkBacks
Attached is a document that contains a column of numbers that I would like to average. It also contains zeros that I would like to omit. the formula is done, but for some reason It is giving me a #VALUE error.
Attached is a document that contains a column of numbers that I would like to average. It also contains zeros that I would like to omit. the formula is done, but for some reason It is giving me a #VALUE error.
Is it an array formula? I.e. you might need to confirm it with CTRL+SHIFT+ENTER keys to get the { } brackets around it.
If not, then try again attaching the file.
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.
:D yeah that did it. I may as well still attach this, because I am also having trouble figuring out the best way to graph this, (due to the zeros).Originally Posted by NBVC
I need to compare data In columns L and M in correlation to the date (column A)
Can you please repost the thread with the new question in the Charting forum, in order to keep organization. \
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks