View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Dunn Steve Dunn is offline
external usenet poster
 
Posts: 193
Default Minimum nonzero value for non-adjacent columns

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