SUBTOTAL - dynamic selection
 

I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]), and
when the cell is selected, a little arrow appears and it allows me to select
the SUBTOTAL function (sum, average, min, max, etc).

This is brilliant - anyone know how this is achieved? I can't find any
macro or indeed any range named 2008.

SUBTOTAL - dynamic selection
 

Hi,

The range has been converted to a list (Ctrl+L or Data List). Once you do
that, you can insert a total row which will allow you to select the function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Totteridge Ram" wrote in message
...
I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]), and
when the cell is selected, a little arrow appears and it allows me to
select
the SUBTOTAL function (sum, average, min, max, etc).

This is brilliant - anyone know how this is achieved? I can't find any
macro or indeed any range named 2008.

SUBTOTAL - dynamic selection
 

Thanks. I think I get this, but I can't find the Data List option (I use
Excel 2007) - is it there?

"Ashish Mathur" wrote:

Hi,

The range has been converted to a list (Ctrl+L or Data List). Once you do
that, you can insert a total row which will allow you to select the function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Totteridge Ram" wrote in message
...
I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]), and
when the cell is selected, a little arrow appears and it allows me to
select
the SUBTOTAL function (sum, average, min, max, etc).

This is brilliant - anyone know how this is achieved? I can't find any
macro or indeed any range named 2008.

SUBTOTAL - dynamic selection
 

Hi,

It is in Insert Table

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Totteridge Ram" wrote in message
...
Thanks. I think I get this, but I can't find the Data List option (I
use
Excel 2007) - is it there?

"Ashish Mathur" wrote:

Hi,

The range has been converted to a list (Ctrl+L or Data List). Once you
do
that, you can insert a total row which will allow you to select the
function

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Totteridge Ram" wrote in
message
...
I have a MS Excel B/S template with the formula =SUBTOTAL(101,[2008]),
and
when the cell is selected, a little arrow appears and it allows me to
select
the SUBTOTAL function (sum, average, min, max, etc).

This is brilliant - anyone know how this is achieved? I can't find any
macro or indeed any range named 2008.