SUBTOTAL - dynamic selection

T

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.
 
A

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
 
T

Totteridge Ram

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

Ashish Mathur said:
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 said:
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.
 
A

Ashish Mathur

Hi,

It is in Insert > Table

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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

Ashish Mathur said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top