http://tinyurl.com/dhtnw

Only a couple of days ago...

Biff

"JohnGuts" wrote in message
...
I have a list in Column H whose MAX size is H2:H10,000. There are
currently
only 1,000 cells filled in with data in column H. I want to create a new
list in column K that will pull out ONLY unique entries from column H. Is
there a formula to use that would calculate for the entire range of column
H
(H2:H10000) so that when a new record is entered, it will automatically
pull
out the unique value if the value added to the new row is unique? Thanks
in
advance for any help! John