[QUOTE=Bob Phillips;2391821]I would create a simple uDF

[code]

Bob,

must concede that the uDF thing is not too transparent for me. I used to make functions and macros in separate sheets writing the code in cells but ever since the Visual Basic Editor, I can't figure out how to make a function.

It was probably supposed to make things better, but I'm lost. Can't find how you name the project or make it a function. It wasn't that that was so obvious with the old system but I had figured it out.

Then I'd love to understand how your func tion actually accomplishes the goal.

Meantime I came up with a workaround. I sorted the data by precinct number and I inserted a column next to the precinct column and if the precinct column were A, put in this formula in B2: =IF(A2=A3,0,A2) and then filled that formula down the entire column. So this will only put a value in the B column if the value in the next row is not the same. Then I sort on the B column and get a sorted list of precincts.

Thanks for taking the time to respond,

Brian