ExcelBanter - Compare columns remove duplicates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Compare columns remove duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/123418-compare-columns-remove-duplicates.html)

Tommy Geek

Compare columns remove duplicates

How might I compare 2 columns (A,B) on an excel worksheet and remove
duplicates from column A?

Teethless mama

Compare columns remove duplicates

Create a helper column
C2 =COUNTIF($B$2:$B$100,A2)
copy as far as needed
AutoFilter all the 1s (which are duplicates), then delete

"Tommy Geek" wrote:

How might I compare 2 columns (A,B) on an excel worksheet and remove
duplicates from column A?

All times are GMT +1. The time now is 05:58 AM.