Re: Simplify formulas

Try this *array* formula:

=SUM(LARGE(A1:A1000,ROW(A1:A500)))
--
Array formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the
regular <Enter>, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"0-0 Wai Wai ^-^" <x@xxxxx> wrote in message
news:uxy1QC6jFHA.708@xxxxxxxxxxxxxxxxxxxxxxx
I would like to simplify the following formulas
=SUM( LARGE(A1:A1000,{1,2,3...500}) )

Is it possible to simplify "{1,2,3...500}"?
Currently I need to type each number manually by myself, ie
1,2,3,4,5,6,7,8,9
and so on which is time-consuming.
Is there any expression which tells the computer that it's "from 1 to 500"?

--
Additional information:
- I'm using Office XP
- I'm using Windows XP




.

Relevant Pages
Loading