Forum Discussion

MDLeach's avatar
MDLeach
Copper Contributor
Jan 29, 2024
Solved

Excel Pattern Recognition when Copying a Formula

I am trying to copy a formula down one row, but the data is from every third row on a different sheet and Excel isn't recognizing the pattern. I've built the pattern out seven times so it should be a...
  • HansVogelaar's avatar
    Jan 29, 2024

    MDLeach 

    In row 8:

     

    =INDEX(Essbase!F:F, 3*ROW()+3)/INDEX(Essbase!R:R, 3*ROW())-1

     

    Fill down.

Resources