Solved: filtering, maybe?

[vzachin]

hi,

i've been out of it for a while. i have 2 columns of data. is there any way to place any value that appears only once in column A into column D. I would need the corresponding value in Column B to be copied to column E. i tried the advance filter, unique records only but that didn't seem to work. i thought i have seen an answer posted here in the past.



thanks in advance
zach

[Bob Phillips]

.

[vzachin]

thanks el xld,

that formula is simply amazing! now to figure out how it works.

zach