vzachin
02-12-2007, 12:13 PM
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
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