abutler1986
New Member
- Joined
- Mar 11, 2015
- Messages
- 34
Hi Experts,
I was wondering if you can please assist me.
I need to somehow create a list of unique entities based on a column, then for each occurrence show the percentage of the total? Just to make it slightly harder, I only want to take the first two characters from each occurrence.
Example:
Column A:
HP18 8GH
HP18 8GH
HP18 8GH
SE21 17H
SE21 17H
LU7 6HH
LU8 1JJ
HP17 7HG
S045 4HW
9 in Total..
I need to show on a separate tab as:
HP - 4 - (4/9)
SE - 2 - (2/9)
LU - 2 - (2/9)
SO - 1 - (1/9)
Hope someone can help me!
Thanks,
I was wondering if you can please assist me.
I need to somehow create a list of unique entities based on a column, then for each occurrence show the percentage of the total? Just to make it slightly harder, I only want to take the first two characters from each occurrence.
Example:
Column A:
HP18 8GH
HP18 8GH
HP18 8GH
SE21 17H
SE21 17H
LU7 6HH
LU8 1JJ
HP17 7HG
S045 4HW
9 in Total..
I need to show on a separate tab as:
HP - 4 - (4/9)
SE - 2 - (2/9)
LU - 2 - (2/9)
SO - 1 - (1/9)
Hope someone can help me!
Thanks,