Hi Art,

Wouldn't mind seeing the macro. sam_518AThotmailDOTcoDOTuk

Thanks
Sam

Art Farrell wrote:
Hi Sam,

Domenic has given you a fine answer using formulas as you asked. I looked at
it from a macro standpoint and if you're interested in that version send me
your email address.

CHORDially,
Art Farrell

Hi All,

I require a Formula to calculate the intervals between each individual
occurrence of a TEXT value (the number of Rows between the LAST instance and
the PREVIOUS instance) in a column, and return each interval result to a
separate Column on the same Row - starting with the most recent ( the
LAST)
occurrence.

[quoted text clipped - 12 lines]
ColC Houses the Text values 55-56
Where I have written the word blank (purely as a visual aid) in ColB - is
a
Formula that has returned empty text.

[quoted text clipped - 22 lines]
Row numbers as explained above. The results should be returned in a
horizontal array to a new Sheet - using a separate column for each TEXT
value
instance - interval calculation.

In the above example, Row397 is the LAST Row with an instance of a TEXT value
- this should be the basis for the FIRST calculated interval returned to
the
New Sheet column B, Row380 should be used for the SECOND calculated interval
returned to column C etc.
[quoted text clipped - 29 lines]
Thanks
Sam


--
Message posted via http://www.officekb.com