Minimum nonzero value for non-adjacent columns
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
.
.
|