hi there i was wondering how i would go about this:
lets say i have a column on worsheet1 that has this
hat
hat
hat
cat
cat
mat
mat
mat
mat
dog
dog
dog
on worksheet 2 column a i would like to have the result returned just once for each group
hat
cat
mat
dog
lets say i have a column on worsheet1 that has this
hat
hat
hat
cat
cat
mat
mat
mat
mat
dog
dog
dog
on worksheet 2 column a i would like to have the result returned just once for each group
hat
cat
mat
dog