.... sorry posted too early:

If it was only columns A and N, (as opposed to A to N) then your solution is
the correct one. And I think your solution is what the OP wanted!

Mea culpa!


"Mike H" wrote:

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