如何将Excel两列数据比较后不重复的数据复制到另一列上

假如你要比较A列与B列数据是否重复,应该有三种结果(即AB皆有,A有B无,B有A无),可在C列存放A有B无的数据,在D列存放B有A无的数据,然后再将两列数据合并即可,方法如下:
1.在C1单元格输入公式:
=IF(COUNTIF($B:$B,A1)=0,A1,"")
在D1单元格输入公式：
=IF(COUNTIF($A:$A,B1)=0,B1,"")
将两个公式用填充柄向下复制到相应的行。
2.按C列排序，将C列数据集中在一起，将其复制到另一工作表的A列；再按D列排序，将D列数据集中在一起，并将其复制到另一工作表的A列的尾部。（注意：这两个操作要用"选择性粘贴/数值"进行粘贴）
3.删除原表的CD两列，将另一工作表中A列的数据复制回原表的C列。

Prettifier使用规则

<pre class="prettyprint lang-html">
The lang-* class specifies the language file extensions.
File extensions supported by default include
   "bsh", "c", "cc", "cpp", "cs", "csh", "cyc", "cv", "htm", "html",
   "java", "js", "m", "mxml", "perl", "pl", "pm", "py", "rb", "sh",
   "xhtml", "xml", "xsl".
</pre>

Prettyprint Latex

% !TEX TS-program = xelatex
% !TEX encoding = UTF-8
 
% This is a simple template for a XeLaTeX document using the "article" class,
% with the fontspec package to easily select fonts.
 
\documentclass[10pt]{ctexart}  % use larger type; default would be 10pt
\setCJKfamilyfont{xinximingti}{PMingLiU}
 
\pagestyle{plain}
 
\usepackage{makeidx}
\usepackage{latexsym,bm,amsfonts,amssymb,mathrsfs}
\usepackage{fontspec} % Font selection for XeLaTeX; see fontspec.pdf for documentation
\usepackage{xunicode} % Unicode support for LaTeX character names (accents, European chars, etc)
\usepackage{xltxtra} % Extra customizations for XeLaTeX % other LaTeX packages.....
\usepackage{geometry} % See geometry.pdf to learn the layout options. There are lots.
\geometry{a4paper} % or letterpaper (US) or a5paper or....
\usepackage[parfill]{parskip} % Activate to begin paragraphs with an empty line rather than an indent
\usepackage{graphicx} % support the \includegraphics command and options
\usepackage{xcolor}
\usepackage{indentfirst}
 
%\setlength{\voffset}{-15.4mm}
%\setlength{\hoffset}{-2.4mm}
\setlength{\parskip}{0pt}
 
%\addtolength{\hoffset}{-2.5cm}
%\addtolength{\textwidth}{2cm}
 
%\linespread{1}
\makeindex   %激活索引命令
 
\title{\LaTeXe{}学习笔记}