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