Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 33

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Large	Invoice	Excel Worksheet Functions	2	May 8th 07 02:19 PM
to large if formula	allertonagain	Excel Worksheet Functions	2	February 13th 06 10:14 AM
IF Function too Large	Trying Hard	Excel Discussion (Misc queries)	3	February 12th 06 05:00 PM
IF Function too Large	Trying Hard	Excel Discussion (Misc queries)	2	February 12th 06 02:01 AM
Image To Large	Minitman	Excel Discussion (Misc queries)	1	July 29th 05 02:41 PM

All times are GMT +1. The time now is 05:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us