-
Solved: Counting account numbers
Hi there
I have a sheet with multiple pages which has multiple occurrences of account numbers and I need to be able to count how many unique account numbers there are. The sheet varies in size as entries are created and deleted. E.G.
1234561P3
1526330P2
2566323P0
1234561P3 appears already
4122545P2
1234561P3 appears already
4122545P2 appears already
So the count would be 4 (note the 8th character is always P - although doubt this makes a difference)
Any help greatly appreciated
thanks
Jon
-
See if you can use or adapt one of the methods shown here:
http://gregmaxey.mvps.org/Sorting_Li...o_methods).htm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules