Try this:

=LARGE(jan!$AA$54:$AA$57,ROWS(A$3:A3))

--
Biff
Microsoft Excel MVP


"jeel" wrote in message
...
I am moving info using the LARGE 1, LARGE 2, LARGE 3, LARGE 4. I need the
info
sorted in groups of 4. I put the formula in the first cell, A3,
=LARGE(jan!$AA$54:$AA$57,1). When I copy it down the 1 on the end of
the formula stays 1. Then I have manually go back and change to 2,3,4.
Is there a way to get it to change since I have lots of them to do?
Thank you, jeel