Solved

# Drag excel formular and auto increment a number

Posted on 2013-12-13

Hi all,

I am tring to copy the below code down in my exel spread sheet so it does the following

=LARGE(IF(Result!$N$2:$N$1000=7,Result!$O$2:$O$1000,""),1)

=LARGE(IF(Result!$N$2:$N$1000=7,Result!$O$2:$O$1000,""),2)

=LARGE(IF(Result!$N$2:$N$1000=7,Result!$O$2:$O$1000,""),3)

=LARGE(IF(Result!$N$2:$N$1000=7,Result!$O$2:$O$1000,""),4)

=LARGE(IF(Result!$N$2:$N$1000=7,Result!$O$2:$O$1000,""),5)

------------------------------------------------------------------------------

=LARGE(IF(Result!$N$2:$N$1000=8,Result!$O$2:$O$1000,""),1)

=LARGE(IF(Result!$N$2:$N$1000=8,Result!$O$2:$O$1000,""),2)

=LARGE(IF(Result!$N$2:$N$1000=8,Result!$O$2:$O$1000,""),3)

=LARGE(IF(Result!$N$2:$N$1000=8,Result!$O$2:$O$1000,""),4)

=LARGE(IF(Result!$N$2:$N$1000=8,Result!$O$2:$O$1000,""),5)

------------------------------------------------------------------------------

(--- indicates a empty row)

I have tried to drap and drop it down so the number after Result!$N$2:$N$1000= increases each time but it just loops round!!!! any ideas how i can just copy it down???