try this straight table with dimension ref_Number:
ref_Number count(ref_Number)-1 Raccc125 1
This shows that the only ref_Number that repeated was Raccc125 which repeated once.
To see how many repeats of ref_Number and Value add Value as a dimension. Normally Values we treat as the basis for an expression but in this case it makes sense to treat as a dimension.
ref_Number Value count(ref_Number)-1 Raccc125 500 1