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