I am also not familiar with VBA. Thanks to your code I now have my
excel sheet working. It is not perfect but it will have to do. I had
to do an itermediate step to get the unique data into a validation
select box. First I used your code to get me all the uniques from an
array and then I put the unique list into a validation select box.
This still has it's problems. I made the array longer than was needed
before I gave it to the select box in case there was any additional
records added in the future. This takes care of what I wanted to make
the worksheet do but it has alot of blanks and 'FALSE' items solely
there for expansion. Do you know how to change the function to return
as a blank field if there are no more unique items available instead of
returning 'FALSE'.

Thank you for your time.

Jeff