Hi,
In column A I have a list of numbers as below:
A1. 1
A2. 2
A3. 1
A4. 3
A5. 4
A6. 3
A7. 5
A8. 5
In column B I want a formula that looks at the value in Column A, for example cell A1 is the 1 value, and returns the value 2 because there are two number 1s in column A. Similarly, cell A3 will also return the 2 value.
Many Thanks
David
Bookmarks