mathewrtaylor
New Member
- Joined
- Aug 28, 2014
- Messages
- 5
Hey Team, I've been racking my brain on this, and either I'm over complicating or overlooking it.
Here's the scenario:
Addy 1
Addy 2
Addy 1
Addy 4
Addy 4
Addy 3
Bart 1
Bart 1
I'd like to count the number of unique values (regardless of what the numbers are). The desired output is: Addy 4, Bart 1. I've been trying to see how to do this, but other than adding an identifier along the original data (which I don't particularly want to do) and adding that number, I can't see an alternative. Any suggestions or recommendations?
This site has been a primary source of knowledge for me over the years and the first time I couldn't find an answer, so finally registered!
Mathew
Here's the scenario:
Addy 1
Addy 2
Addy 1
Addy 4
Addy 4
Addy 3
Bart 1
Bart 1
I'd like to count the number of unique values (regardless of what the numbers are). The desired output is: Addy 4, Bart 1. I've been trying to see how to do this, but other than adding an identifier along the original data (which I don't particularly want to do) and adding that number, I can't see an alternative. Any suggestions or recommendations?
This site has been a primary source of knowledge for me over the years and the first time I couldn't find an answer, so finally registered!
Mathew