https://bugs.documentfoundation.org/show_bug.cgi?id=167829
--- Comment #1 from vic <[email protected]> --- > The following is for selecting every 3rd number in a column range: > > =INDEX($monthly.b$2:b$100, 3*(row()-row(J$2))+1,1) > vs > =[3*(r-r([2])+2] Sorry, I rushed and didn't specify the column & sheet: Assumming the result column is to be 3 cols to the right and in sheet 2, while "monthly" is sheet 1: =[3*(r-r([2]))+2, c-3, 1] -- You are receiving this mail because: You are the assignee for the bug.
