ljm Posted May 3, 2007 Share Posted May 3, 2007 I am trying to get a count of all the unique names in a list - I can get a count of all the names in the list, but am stumped on how to get the count to be just the unique values. For instance Linda Linda Linda James would return 2 Thanks, Linda Link to comment Share on other sites More sharing options...
Raybaudi Posted May 3, 2007 Share Posted May 3, 2007 Hi where is stored this list of names ? Link to comment Share on other sites More sharing options...
ljm Posted May 3, 2007 Author Share Posted May 3, 2007 It is a group name field that I sort on so the example should be like this Rec 1 Group Name = Linda Rec 2 Group Name = Linda Rec 3 Group Name = Linda Rec 4 Group Name = James When I sort by group name I can count the members of the groups, but would like a count of groups as well, hence the unique. Link to comment Share on other sites More sharing options...
comment Posted May 3, 2007 Share Posted May 3, 2007 See if this helps. Link to comment Share on other sites More sharing options...
ljm Posted May 3, 2007 Author Share Posted May 3, 2007 That's done it! Thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6201 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now