"DAP" wrote:
You are a Stud ! Worked great

That's good. But could you press the "Yes" button in that response since it
answered your original query

It works but I dont really understand why?
Please explain the offset command and the command Rows ($1:1)*6-6 ?

This is a second query. Just a couple of add-ons, assuming you have since
updated your knowledge in Excel's help as per David's comment

ROWS($1:1)*6-6 is the row param in OFFSET

To see what the above does (you could this in general for any nested
functions), just put in any cell: =ROWS($1:1)*6-6, then copy it down. You
would find it simply generates the number series: 0, 6, 12, ... . These
numbers (incrementing as desired) are then used as the row param in OFFSET to
return the required results based on the OFFSET's anchor cell.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---