I’m using a referenced cell to pull through a ranked date, however everytime the date changes, rather than the referenced cell now showing to new date, I get an error.
“the referenced cell location cannot be found becuase its target no longer exists”
I’m struggling to figure out how to fix the issue, any ideas?
I used to just a single, large table but this had an error, now they are individual tables, it still causes problems.
The tables look as such:
The reference is pointing at the cell with the date in.
The date for each cell is populated with a variable that reads:
= [Date Day] Where ( [Rank - Date Day] = 1 )
The figure changes dependent on which rank day I want to see.
The [Rank - Date Day] variable looks like this:
= Rank ( [Date Day] )
Essentially, I need it to populate a table(s) that show the best and worst product, and the number of sales.
I’m using Rank rather than Relative as I don’t want to have blanks in the table (as we do not work all weekends, but sometimes we do, therefore it is a contestant variable.
Any help is appreciated.