When comparing values in a row to the row above it, the row replicator doesn't keep the formula consistent. At some point, the comparison looks 2 rows above instead of one row above.
Date
Votes
2 comments
-
Harry Lewis I have not been able to duplicate the issue you describe.
Since I cannot see all your functions, here is the simple layout I am using:
How does this differ from what you are attempting?
-
Yvonne Jury What I was attempting is no different than what you're illustrating here. I still couldn't get it to work by just using a simple = to reference the cell above. What did work was using =INDIRECT(ADDRESS(ROW()-1,COLUMN())) to reference the cell above. Works perfectly!
Please sign in to leave a comment.