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

"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

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)

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.

"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

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


"Rick Rothstein (MVP - VB)" wrote in
message ...
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)

Would this work for you?

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

Rick

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)

Would this work for you?

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

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

with result in row 1

=SMALL(A:N,ROW())

copy down for 2nd, 3rd etc smallest

"Tom" wrote:

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

"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

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

Would this formula include Cols B - M also?

"Toppers" wrote:

with result in row 1

=SMALL(A:N,ROW())

copy down for 2nd, 3rd etc smallest

"Tom" wrote:

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

"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

It would

"Mike H" wrote:

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

Would this formula include Cols B - M also?

"Toppers" wrote:

with result in row 1

=SMALL(A:N,ROW())

copy down for 2nd, 3rd etc smallest

"Tom" wrote:

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

"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

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

Thank everyone for suggestions
Eric