 |
 | 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 / Worksheet Functions / May 2008Find Smallest entry but excluding zero
I need to find the smallest number in a column which may have the range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf so that I can calculate the lowest number of strokes taken. Zere means that they have wiped the hole and therefore cannot be used. Thanks EPJ Try SMALL(A1:A100,1+COUNTIF(A1:A100,0)) Mike > I need to find the smallest number in a column which may have the > range from 0 to 9 but need to exclude 0 ie: strokes in a game of golf > so that I can calculate the lowest number of strokes taken. Zere means > that they have wiped the hole and therefore cannot be used. > Thanks EPJ I like that one, clever!  SignatureSandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Try > [quoted text clipped - 7 lines] >> that they have wiped the hole and therefore cannot be used. >> Thanks EPJ I only risked it with a golf question because it falls over with negative values. But who ever got a hole in -1 :) Mike > I like that one, clever! > [quoted text clipped - 9 lines] > >> that they have wiped the hole and therefore cannot be used. > >> Thanks EPJ |
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.