I have a column of about 9700 values, many of which are duplicates. What I would like to do is be able to look at a cell and determine whether its duplicate value occurs before (lower row number) or after (higher row number) than that one.

My plan was to use a combination of for/next and .findnext, but I've at this point in my two-weeks of vba experience not been able to make .find or .findnext work. Basically my plan was to change the right border of a cell's value for "appears below" and the left border for "appears above." This would avoid the confusion of a cell sharing a top or bottom border with another cell.

Does anybody have any suggestions? It seems like a fun puzzle to work out, but I think I'm out of my depth.

Thanks very much to all of you.