Hi All,

Is it possible to adapt Formulas using A1 style notation to use Dynamic
Named Ranges?

1. Find the LAST numeric value in a single column of a Dynamic named Range.
The column also contains valid zero’s and invalid blanks (empty cells).

=INDEX(A:A,MATCH(9.99999999999999E307,A:A))

=INDEX(COST,MATCH(9.99999999999999E307,COST)) ?


2. Sum the LAST 5 numeric values in a single column Dynamic named Range .
The column also contains valid zero’s and invalid blanks (empty cells).


3. Sum the 5 LARGEST numeric values. I have 20 Columns and 500 Rows of
data. The Range is called Database. I need to use two columns from Database
to provide the answer. The first column I reference is called Total – that
holds the 5 Largest values, then I need to SUM the 5 corresponding values
in Column 18.

=INDEX(Database,SUM(LARGE(Total,Row(1:5))),18) ?


Assistance very much appreciated.

Regards,
Sam

--
Message posted via http://www.officekb.com