Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
elgaer
Remove duplicates across columns in Excel 2010?
I have numeric data in 4 columns, I need to compare column B to A and remove duplicates from B, then compare column C to A and B and remove duplicates from C and so on. So in the end I am left with four columns of data, all with unique info. The remove duplicates features seems to simply check each column against itself and does not compare the different columns. Each column's data has significance so I need it to stay in those columns. Thanks
3 AnswersSoftware10 years ago