Hallo,
I've this little problem to solve.
I have a list of names in a column. Every name has one of the following values to associate with: 1 or 0.5.
- Mr John (value 1)
- Mr Morrison (value 0.5)
- Mr Morrison (value 0.5) (a single name could be present more times)
- Mr X (value 1)
- Mr X...