Welsh Mark3
Board Regular
- Joined
- Apr 7, 2014
- Messages
- 164
- Office Version
- 365
I'm looking to create a formula that 'rank' an occurrence in the file, I guess similar to the count function but rather than the number of times it appears, I want where it appears in that range of occurrences.
<tbody>
</tbody>
Column A | Desired Result | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 2 | |
<tbody> </tbody> | 3 | |
<tbody> </tbody> | 1 | |
<tbody> </tbody> | 1 |
<tbody>
</tbody>