e.g. =AVERAGE(IF(MOD(ROW($N$2:$N$54),54)=2,$N$2:$N$54)), If I drag it copies but remain the same all the way down, therefore giving the same answer as the first ROW.
e.g. =AVERAGE(IF(MOD(ROW($N$2:$N$54),54)=2,$N$2:$N$54)), If I drag it copies but remain the same all the way down, therefore giving the same answer as the first ROW.
Last edited by Thamsanqa; 06-27-2014 at 10:59 AM.
Not sure what you are trying to get. But you have to use relative references if you want the references to be changed.
Formula:Please Login or Register to view this content.
________________________________________________________
If your problem is solved, update the thread as SOLVED: Go to the top of the first post-Select Thread Tools-Select Mark thread as Solved OR - Go to the first post - Click edit- Click Advance- Just below the word "Title:" you will see a dropdown with the word No prefix.- Change to Solve- Click Save.
Show your gratitude to the person who helped you solving your problem by clicking on star button at the bottom of such post.
Thanks Haripopuri, problem not solve, not sure how to attach the sample please advise..
Click on Go Advanced > Manage Attachments
file is up loaded...
Thamsanqa, a simple average formula works on your data. Enter this and drag down below.
Formula:Please Login or Register to view this content.
But I guess in your first formula, you are trying to do more than just average using MOD & ROW. but your file does not reflect actual info. Can help if you let me know exact requirement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks