Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LARGE 1, LARGE 2, LARGE 3, LARGE 4
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LARGE 1, LARGE 2, LARGE 3, LARGE 4
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
LARGE 1, LARGE 2, LARGE 3, LARGE 4
If the formula starts in cell A3 then in place of 1 use "Row() - 2" and drag
down. The logic being that "Row()" returns 3 for cell A3, and when you minus 2 the result is 1. For the next cell (A4), "Row()" returns 4, and when you minus 2 the result is 2 and so on. Regards, Greg "jeel" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Large | Excel Worksheet Functions | |||
to large if formula | Excel Worksheet Functions | |||
IF Function too Large | Excel Discussion (Misc queries) | |||
IF Function too Large | Excel Discussion (Misc queries) | |||
Image To Large | Excel Discussion (Misc queries) |