Subtotal

[Kimme]

Hi,
We have the Min and Max subtotal for example:
=subtotal(5,A1:A100)
=subtotal(4,A1:A100)
Do we have subtotal, funtion_number for Median, first
Quartile and third Quartile?

Thanks,

 

[Ron Rosenfeld]

Hi,
We have the Min and Max subtotal for example:
=subtotal(5,A1:A100)
=subtotal(4,A1:A100)
Do we have subtotal, funtion_number for Median, first
Quartile and third Quartile?

Thanks,

You will find the Subtotal functions listed if you go to HELP for Subtotals.


--ron

 

[Kimme]

Thanks for your Reply
Yes, I found
1 Average
2 Count
3 CountA
4 Max
5 Min
6 Product
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
I am looking for the subtotal for Median, first quartile
and third quartile? I am using this for Boxplot and
whisker chart.
Thanks,

 

[Frank Kabel]

Hi
for the Median try the following array formula entered with
CTRL+SHIFT+ENTER (assumption: column A contains your values):
=MEDIAN(IF(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$100,1,1),ROW($A$1:$A$100)-RO
W(INDEX($A$1:$A$100,1,1)),0))=1,$A$1:$A$100))

 

[Kimme]

Hi,
The formula didn't work, any more ideas or suggestions.

Thanks for your help.

 

[Ron Rosenfeld]

Thanks for your Reply
Yes, I found
1 Average
2 Count
3 CountA
4 Max
5 Min
6 Product
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP
I am looking for the subtotal for Median, first quartile
and third quartile?

Well, as you see, there is no subtotal for those functions.

Perhaps more information about your data might help in solving your problem
using some other method.


--ron

 

[Frank Kabel]

Hi
works for me. what is the exact error you got. Also have you entered
the formula as array formula?

 

[Kimme]

Hi,
I did, copy and paste your formula also.

Thanks,

 

[Frank Kabel]

Hi
if you like email me an example sheet