Solved: Counting account numbers

[Blackie50]

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

[gmaxey]

See if you can use or adapt one of the methods shown here:

http://gregmaxey.mvps.org/Sorting_Lists_(Macro_methods).htm