Dear Friends
I use Xls 2003 and I would like to ask for help in the following problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to copy my
non-contiguous range to a contiguous range) or named ranges because there are
too many rows involved.

Thanks in advance,
Catalin

Hi Catalin,

how many columns are we talking about, and are they regularly or randomly
seperated?

Knowing the columns involved may aid with the solution.


"Catalin" wrote in message
...
Dear Friends
I use Xls 2003 and I would like to ask for help in the following problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to copy my
non-contiguous range to a contiguous range) or named ranges because there
are
too many rows involved.

Thanks in advance,
Catalin

Hi Steve

I am talking about 5 columns, in this case regularly separated by 2 other
columns.

rgds,
Catalin

"Steve Dunn" wrote:

Hi Catalin,

how many columns are we talking about, and are they regularly or randomly
seperated?

Knowing the columns involved may aid with the solution.


"Catalin" wrote in message
...
Dear Friends
I use Xls 2003 and I would like to ask for help in the following problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to copy my
non-contiguous range to a contiguous range) or named ranges because there
are
too many rows involved.

Thanks in advance,
Catalin

.

I am talking about 5 columns, in this case
regularly separated by 2 other columns.

How about telling us the specific cells that you want to evaluate? Like:

A2, D2, G2, J2, M2

Is there numeric data in the cells between the target cells? For example,
what's in B2 and C2?

--
Biff
Microsoft Excel MVP


"Catalin" wrote in message
...
Hi Steve

I am talking about 5 columns, in this case regularly separated by 2 other
columns.

rgds,
Catalin

"Steve Dunn" wrote:

Hi Catalin,

how many columns are we talking about, and are they regularly or randomly
seperated?

Knowing the columns involved may aid with the solution.


"Catalin" wrote in message
...
Dear Friends
I use Xls 2003 and I would like to ask for help in the following
problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to copy
my
non-contiguous range to a contiguous range) or named ranges because
there
are
too many rows involved.

Thanks in advance,
Catalin

.

There are the following columns from which I would like to extract the
minimum values: G, J, M, P, S.
Between those columns there are others with text or numer data.

So I need to evaluate for example G5,J5,M5,P5 and S5 and so on...

Thanks and regards,
Catalin



"T. Valko" wrote:

I am talking about 5 columns, in this case
regularly separated by 2 other columns.

How about telling us the specific cells that you want to evaluate? Like:

A2, D2, G2, J2, M2

Is there numeric data in the cells between the target cells? For example,
what's in B2 and C2?

--
Biff
Microsoft Excel MVP


"Catalin" wrote in message
...
Hi Steve

I am talking about 5 columns, in this case regularly separated by 2 other
columns.

rgds,
Catalin

"Steve Dunn" wrote:

Hi Catalin,

how many columns are we talking about, and are they regularly or randomly
seperated?

Knowing the columns involved may aid with the solution.


"Catalin" wrote in message
...
Dear Friends
I use Xls 2003 and I would like to ask for help in the following
problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to copy
my
non-contiguous range to a contiguous range) or named ranges because
there
are
too many rows involved.

Thanks in advance,
Catalin

.



.

I need to extract the mimimum value
(higher than zero) on each row.

Try this array formula** :

=MIN(IF(MOD(COLUMN(G5:S5),3)=1,IF(G5:S50,G5:S5)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Caveat: inserting new columns before or within the referenced range will
cause the formula to "break" !

--
Biff
Microsoft Excel MVP


"Catalin" wrote in message
...
There are the following columns from which I would like to extract the
minimum values: G, J, M, P, S.
Between those columns there are others with text or numer data.

So I need to evaluate for example G5,J5,M5,P5 and S5 and so on...

Thanks and regards,
Catalin



"T. Valko" wrote:

I am talking about 5 columns, in this case
regularly separated by 2 other columns.

How about telling us the specific cells that you want to evaluate? Like:

A2, D2, G2, J2, M2

Is there numeric data in the cells between the target cells? For example,
what's in B2 and C2?

--
Biff
Microsoft Excel MVP


"Catalin" wrote in message
...
Hi Steve

I am talking about 5 columns, in this case regularly separated by 2
other
columns.

rgds,
Catalin

"Steve Dunn" wrote:

Hi Catalin,

how many columns are we talking about, and are they regularly or
randomly
seperated?

Knowing the columns involved may aid with the solution.


"Catalin" wrote in message
...
Dear Friends
I use Xls 2003 and I would like to ask for help in the following
problem:

I have separate (non-adjacent) columns of data.
I need to extract the mimimum value (higher than zero) on each row.

I would like to have a solution without using helping ranges (to
copy
my
non-contiguous range to a contiguous range) or named ranges because
there
are
too many rows involved.

Thanks in advance,
Catalin

.



.