silverlucky5
New Member
- Joined
- Sep 8, 2009
- Messages
- 35
My problem is this: |
I have a column of numbers that are not necessarily sequential and are not sorted numerically. |
Using a formula, I would like to return the relative number of those numbers in a new column. |
For example: I have a column of 4 numbers: 1, 1, 4, 2, 1, 1, 5. I want to return, respectively, in a new column: 1, 1, 3, 2, 1, 1, 4. |
I have tried all kinds of formulas using INDEX, MATCH, SMALL, LARGE, MIN, MAX, but just can't seem to figure it out. |
I have attached sample data in case needed. https://www.dropbox.com/s/1djt8sfv40acwmi/Absolute Reference.xlsx?dl=0 |
Any help would be greatly appreciated! |
Thanks! |
<tbody>
</tbody>