 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Finding the lowest mode in a set of numbers
Using Excel 2002, I am analyzing sets of numbers. One statistic Ii look at is the Mode. If the set of numbers has more than 1 mode, how can I get the Mode function to return the lowest Mode? Thanks, Tonso See Harlan Groove's comment in: http://www.microsoft.com/office/community/en-us/default.mspx?&query=more+than+on e+mode&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functi ons&p=1&tid=abcc6020-b02a-4790-96b4-6d1599f4611d  SignatureGary''s Student - gsnu2007c > Using Excel 2002, I am analyzing sets of numbers. One statistic Ii > look at is the Mode. If the set of numbers has more than 1 mode, how > can I get the Mode function to return the lowest Mode? > Thanks, > Tonso Maybe this: =MIN(C1:E1) C1:E1 represents the cells that contain the given modes. Adjust this as needed. This formula will return the smallest number between cells C1, D1, and E1. HTH, Paul > Using Excel 2002, I am analyzing sets of numbers. One statistic Ii > look at is the Mode. If the set of numbers has more than 1 mode, how > can I get the Mode function to return the lowest Mode? > Thanks, > Tonso Try this *array* formula on a list in A1 to A20: =MIN(IF(COUNTIF(A1:A20,A1:A20)=MAX(COUNTIF(A1:A20,A1:A20)),A1:A20)) SignatureArray formulas are entered using CSE, <Ctrl> <Shift> <Enter>, instead of the regular <Enter>, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. Also, CSE *must* be used when revising the formula. -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== Using Excel 2002, I am analyzing sets of numbers. One statistic Ii look at is the Mode. If the set of numbers has more than 1 mode, how can I get the Mode function to return the lowest Mode? Thanks, Tonso |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.