Hmm... having difficulty searching for an 'easy' question?
I am trying to find how many rows (periods, not dates) ago a value occurred.
For example,
Col A
5
2
2
8
9
12
3
How many periods ago did "8" occur?
The number 8 occurred four periods (rows) ago.
So I would need a formula that can...