View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Catalin[_2_] Catalin[_2_] is offline
external usenet poster
 
Posts: 16
Default 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

.



.