'Downfill incremetation skip 2 columns

I'm trying do create a master sheet for work, as for nom we work in the middle age, copying some data to up to 4 differents documents and I want that to change :D

I'm quite new to Excel (more than basics I mean), and I have a problem that I can't seem to find a solution online. My sheets are as follow :

simplified version

So in Sheet one, C5 i want the result for sheet 2 E16, but in sheet 1 D5, I want the result for H16.

When I try to use downfill, it doesn't understand that I want to get the results while skipping everytime 2 columns between the results in sheet 2.

The cells are blank in the other cells in Sheet2 row 4, so i would guess there could be some conditionning possible, with a function like isblank, but I'm struggling to understand how I could do it.

Any help?

Thanks a lot for reading this

arraysgoogle-sheetsfiltergoogle-sheets-formulatranspose


Solution 1:[1]

try:

=FILTER(Sheet2!E16:16; MOD(COLUMN(Sheet2!E16:16)+1; 3)=0)

enter image description here

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1

Related Questions