That's likely because some of the cells in Column A contain additional
spaces, special characters, etc. Try cleaning this up and you'll
probably find that the formula will return the desired results.

I understand that there's a utility available to do this very thing. I
believe it's called ASAP. If you'd like to give this a try, you can
search for this utility using Google...

In article ,
spndoc wrote:

Domenic - Thanks, this is very close, however the value 1 is being
replicated. When it ranks it gives a result similar to the following:

1
1
2
3
4
5
1
1
2
3

And so on.

Again very close, but not sure how to prevent the number 1 from replicating
on the first two lines of each state.