period ago

  1. E

    find how many rows ago a value occurred

    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...

Some videos you may like

This Week's Hot Topics