ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sophomoric question... (https://www.excelbanter.com/excel-discussion-misc-queries/93461-sophomoric-question.html)

capnsean

Sophomoric question...
 

I want to find the median of more than 30 elements. What should I do?


--
capnsean
------------------------------------------------------------------------
capnsean's Profile: http://www.excelforum.com/member.php...o&userid=25049
View this thread: http://www.excelforum.com/showthread...hreadid=551075


Chip Pearson

Sophomoric question...
 
Are your numbers in an continuous range? If so, just use
something like

=MEDIAN(A1:A100)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"capnsean"
wrote in
message
...

I want to find the median of more than 30 elements. What
should I do?


--
capnsean
------------------------------------------------------------------------
capnsean's Profile:
http://www.excelforum.com/member.php...o&userid=25049
View this thread:
http://www.excelforum.com/showthread...hreadid=551075





All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com