Copying down a formula

Hello mellow fellows. I have a freaking fantastic formula for fellows (I wanted to write the whole sentence with F, but it wouldn't make sense) such as yourselves. The formula is =LARGE(ABS($A$1:$A$7),1) Now, when I copy this ARRAY formula down in a column, I would like the 1 to increase to 2 and then to 3, etc. It does not do this...It just stays at 1. How could I make it do this? Danks.

Change the 1 to ROWS($1:1) in the formula, i.e.:

=LARGE(ABS($A$1:$A$7),ROWS($1:1))

Don't forget to use CSE to confirm, then you can copy down.

Hope this helps.

Pete

@Debraj

I don't think this is a duplicate thread - this concerns copying a formula down and incrementing, whereas the other thread is about dealing with blanks, although it is the same formula.

Pete

Yes, it is a duplicate of the thread you pointed to in post #3 - he asked a follow-up question and then created a new thread with that question.

Pete