Eric,

1 way. Select columns A & N (Select A hold down Ctrl and selectN) and name
them using insert|name

Then use the formula

=SMALL(myRange,1)

Mike

"Eric" wrote:

I would like to determine the small number fro column A & N only, does anyone
know how to do that? I need to use small function, because I can determine
the second small number and the third small number from lists.
I try following code, but it fails
=SMALL(A:A,N:N,1)

Does anyone have any suggestions?
Thank for any suggestions
Eric