Re: Offset function copying data from every 30th cell (various rows, various columns)
Hi sgdeli,
tried to replicate a bit of your file in sheet1 and the formulas in sheet 2... works like a charm for me!
Copied the formula from B1 in to C1, altered the cellreference in"Sheet1!$D$2" and left "D2" out of "(ROW(D2)-1)*30 and then got the result I wanted!
Did this in the cells A1 ÷ D1 then copy those formulas down for about 15 rows and I got the result I think you want.
I presume there is a type falure or something in your cell C1.
However... using this formula for so many cells (about 600 contacts!), I think it will be very slow!
When there's no typefailure, you could send an example of your file to me. Will take a look then.
Kind regards,
Herman