excel技巧

**************************************************************excel模板处理**************************************************************
=CONCATENATE("insert into tbl_channels_transaction(trans_no,trans_money,merchant_code,merchant_no,trans_status,pay_time,
lock_flg,run_count,lock_tm,create_time,up_time,bank_code,supplier_no,card_type,is_part,pay_mode) values
('",A2,"',",B2,",'",C2,"','",D2,"','040','",E2,"','04',1,'",F2,"','",G2,"','",H2,"','",I2,"','",J2,"','010','0','050');")

=IF(A2=B2,"相同","不同")
=ISNUMBER(MATCH(A1,B:B,))

原文地址:https://www.cnblogs.com/xingminghui/p/7966094.html