How to use small function?

E

Eric

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
 
M

Mike H

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
 
R

Rick Rothstein \(MVP - VB\)

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)
Click to expand...

Would this work for you?

=MIN(SMALL(A:A,1),SMALL(N:N,1))

Rick
 
T

Tom

Try using =SMALL(A1:N75,1)
Substitute the appropriate number for the last row in column N.
 
R

Rick Rothstein \(MVP - VB\)

My formula will work only for the smallest value in the two columns... if
you want the 2nd, 3rd, etc., it won't (necessarily) return the correct value
for those.

Rick
 
R

Rick Rothstein \(MVP - VB\)

I would like to determine the small number fro column A & N only, does
Would this work for you?

=MIN(SMALL(A:A,1),SMALL(N:N,1))
Click to expand...

Duh! Well, of course, for the smallest value, this would have been better...

=MIN(A:A,N:N)

but it won't do for the 2nd, 3rd, etc.

Rick
 
M

Mike H

I would like to determine the small number fro column A & N only

Would this formula include Cols B - M also?
 
T

Toppers

.... 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!
 
Top