| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Smallest entry but excluding zero
Try
SMALL(A1:A100,1+COUNTIF(A1:A100,0)) Mike " wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Smallest entry but excluding zero
I like that one, clever!
-- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Mike H" wrote in message ... Try SMALL(A1:A100,1+COUNTIF(A1:A100,0)) Mike " wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Smallest entry but excluding zero
I only risked it with a golf question because it falls over with negative
values. But who ever got a hole in -1 :) Mike "Sandy Mann" wrote: I like that one, clever! -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Mike H" wrote in message ... Try SMALL(A1:A100,1+COUNTIF(A1:A100,0)) Mike " wrote: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Smallest entry but excluding zero
Works brilliantly, thanks EPJ
On Sun, 11 May 2008 12:05:23 +0100, "Sandy Mann" wrote: I like that one, clever! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Smallest and Largest. | Excel Worksheet Functions | |||
| Find X number of smallest values in a range | Excel Worksheet Functions | |||
| trying to find the smallest with dynamic column changes | Excel Discussion (Misc queries) | |||
| COMPARE DATA AND LIST SMALLEST AND LARGEST ENTRY BY UNIT | Excel Discussion (Misc queries) | |||
| find smallest number not equal to 0 | Excel Worksheet Functions | |||
Linear Mode
