Excel_2017KB_01Common

 Excel2010

 F1帮助

Data->Remove Duplicated

 Data->Text to Columns

 ‘=‘ 倒三角  A1 B1 C1

 Home->Conditional Formatting->Highlight Cell Rules->Duplicated Valus

取代录宏

 “&” 

 =A149&B149

A=OFFSET($C$177,RANDBETWEEN(0,4),)

B=RANDBETWEEN(1000,9999)

A&B=

=VLOOKUP("Full name",$B$1:F216,2,FALSE)

=FIND(":",C249)

=RIGHT(C249,(LEN(C249)-D249))

=FIND("\",C249)

=RIGHT(C249,(LEN(C249)-G249))

Excel_2017KB_01Common

原文：http://www.cnblogs.com/albertzz1987/p/6329479.html