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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks