Hi, here are the two formulas you could use instead:
=INDEX(Sheet!23:23,IF(COLUMN() = 1, 6, COLUMN()*3 + 3) + 3)
=INDEX(Sheet!23:23,IF(COLUMN() = 2, 7, COLUMN()*3 + 1) + 3)
I'm creating a summary sheet to pick certain figures off a large worksheet. I need the last value of every 6th and 7th column and I finally figured out the formulas (the first columns are I and J)
However, if I drag this to the right, the next columns will be the 12th and 13th columns because of each formula skipping a cell. Is there a way to make the formula ignore the skipped cell. Or is there a better formula I can use?
Thanks in advance.