View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kassie kassie is offline
external usenet poster
 
Posts: 515
Default address of first and last number in a row

Hi Kobus,

Your explanation is rather confusing! You are looking for dates, you say?
But you refer to numbers between 1 and 6, and 0's
So where are the dates?

Maybe you should elaborate more, and explain how each row is utilised, so
that we can know what it is that you are trying to achieve?

--
HTH

Kassie

Replace xxx with hotmail


"Kobus" wrote:

I have various rows with numbers entered randomly with 0's inbetween. The
first row has are represents calender dates. I need to find the date of the
first number entry and the date of the last number entry larger than 0. If
of any help the numbers entered are from 1 to 6. These are randomly entered.