How to use small function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Try using =SMALL(A1:N75,1)
Substitute the appropriate number for the last row in column N.
 
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
 
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
 
I would like to determine the small number fro column A & N only

Would this formula include Cols B - M also?
 
.... 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!
 
Back
Top