Search code examples
exceldata-connections

Excel data sync fill down formulas every other

I have a data connection to a csv which fills out cells (A to N), I also have some basic formulas which run matches on that data (O to V).. the data I'm matching is grouped by every 2 rows.

If I import the data I can manually duplicate the formulas to appear like the image below. enter image description here

If I select Fill down formulas in columns adjacent to data within the data connection properties, it will fill the forumals every row, not every second as seen below. enter image description here

Solution

  • You can add a test to see if the row is even or not using mod(): if(mod(row(),2)=0,[your formula],"")