SUBTOTAL - dynamic selection

[Totteridge Ram]

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.

 

[Ashish Mathur]

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]

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

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

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.

 

[Ashish Mathur]

Hi,

It is in Insert > Table

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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

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

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.