Finding the Lowest Numbers

No need for a macro. There's a much simpler way to determine the smallest unique number: =SMALL(UNIQUE(A1:A12),2)

Thank you, Micky, for your UDF.
I always have Option Explicit in my modules, so had to add some Dimension statements but then it worked fine.

I need a formula to select the low four numbers from a column and then add those four numbers.

These are golf match scores. I need to select the low four for a team then add those four scores for a team total.

@Locke,
1) No problem (as for your addition to my formula).
2) in the UDF - you may omit the: nn = Rng.Count
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL

@Micky

No problem. In the cases where you can make the assumption that your range is all numbers (which would be most cases) I would use your solution in a heart beat. I just wanted to add to your solution so that it behaved a little more like the SMALL/LARGE functions. You're formula solution is perfectly valid. :)

Nice UDF!

@Locke,
My suggested formula was written as per the above tip - therefor I didn't considered textual values within the range.
Here is my suggestion for a "sufisticated" UDF.
a) Rng is for the Range of cells.
b) The second argument is the position k.
c) The last argument should be "S" for Small or "L" for Large.
----------------------------------------------
Function Large_SmallUnique(Rng As Range, k, LS)
Dim NewList As New Collection
nn = Rng.Count
On Error Resume Next
For Each CL In Rng
NewList.Add CL, CStr(CL)
Next
ReDim arr(NewList.Count)
For P = 1 To NewList.Count
arr(P) = NewList(P)
Next
If UCase(LS) = "L" Then
Large_SmallUnique = Application.Large(arr, k)
Else
Large_SmallUnique = Application.Small(arr, k)
End If
End Function
-------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL

@Roy,
Allens coding is a USER DEFINED FUNCTION - and as such it MUST be typed into a Module and not in both places you have mentioned.
My previous disclosure remains the same.
Try to study the following link:
http://dmcritchie.mvps.org/excel/getstarted.htm
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL

@Roy

You'll need to create a module. UDFs don't work in Sheet or Workbook objects.

@Micky

In playing with your formula I discovered for the first time that SMALL/LARGE ignore TRUE/FALSE values. Always a new discovery! Not sure how I never realized it before.

I noticed that the formula breaks if your range contains text or boolean values. This can be overcome with the following modification:

=SMALL(IF(FREQUENCY(MATCH($A$1:$A$10,$A$1:$A$10,0),MATCH($A$1:$A$10,$A$1:$A$10,0)),A$1:A$11),ROW(A1))

In a large worksheet, I decide to find the smallest number, so I entered =, then END, then Home. to find all active cells. I then edited the formula to =small(A1:K7580) and received an error. then I added ,2) to the formula and got a 0. So I increased the decimals and still received a zero. So I thought the lowest number must be zero or the formula will not work if some cells contain text, so I edited the formula to =large(A1:a100,1) and received a large number. I then edited my small formula and received a -121 and the other formulas re-computed. Now I'm wondering why my initial entry did not work.

@Micky

My ignorance is showing, I copied Allens coding into both sheet1 and thisworkbook but the function was not available. What did I do wrong?

Roy

@Roy,
Correct assumption, especially as far as my formula is concerned.
***Disclosure:
I didn't examine the proposed UDF.
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL

No need for a UDF.
Assume the range of numbers are in A1:A10:
3
-3
6
7
-2
8
5
5
-2
-3
Now, type the following formula into cell D1 and copy down as far as needed.
=SMALL(IF(FREQUENCY(A$1:A$10,A$1:A$10),A$1:A$11),ROW(A1))
Double click to see a pictured demonstration:
http://postimg.org/image/phqgmhff3/
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2015)
ISRAEL

One assumes you could also use the principle for obtaining the LARGEst unique numbers.