2018-04-14

【示例文件获取方法见文末】

# 1、查找重复值

=IF(COUNTIF(\$A\$3:\$A\$10,A3)>1,"重复","") # 2、重复出现两次以上提示

=IF(COUNTIF(A\$14:A14,A14)>1,"重复","") # 3、根据身份证号提取出生日期

=--TEXT(MID(A25,7,8),"0-00-00") # 4、根据出生年月计算年龄

=DATEDIF(A36,TODAY(),"y") # 5、根据身份证号码提取性别

=IF(MOD(MID(A47,15,3),2),"男","女") # 6、成绩排名

=RANK.EQ(A58,\$A\$58:\$A\$65) # 7、中国式排名（相同分数不占名次）

=SUMPRODUCT((\$A\$69:\$A\$76>A69)/COUNTIF(\$A\$69:\$A\$76,\$A\$69:\$A\$76))+1 # 8、统计不重复个数

=SUMPRODUCT(1/COUNTIF(A80:A87,A80:A87)) # 9、提取不重复值

=INDEX(\$A\$91:\$A\$98,MATCH(,COUNTIF(\$B\$90:B90,\$A\$91:\$A\$98),))&"" # 10、批量翻译

=FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A102&"&doctype=xml&version"),"//translation") # 11、合并单元格求和

=SUM(B109:\$B\$120)-SUM(C110:\$C\$120) 0条评论
{"ft_lang_label":"__label__zh","ft_lang_prob":0.66829896,"math_prob":0.8941842,"size":978,"snap":"2022-40-2023-06","text_gpt3_token_len":680,"char_repetition_ratio":0.08932238,"word_repetition_ratio":0.0,"special_character_ratio":0.41104296,"punctuation_ratio":0.21100917,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9673815,"pos_list":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22],"im_url_duplicate_count":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-09-27T04:16:05Z\",\"WARC-Record-ID\":\"<urn:uuid:f136a76f-8354-4201-a94a-726773943f5f>\",\"Content-Length\":\"55915\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:960dc325-7d4d-4096-a728-f2456b3106e6>\",\"WARC-Concurrent-To\":\"<urn:uuid:7a0b1e6c-64b4-4093-9041-2a6ba4a678b0>\",\"WARC-IP-Address\":\"8.45.176.231\",\"WARC-Target-URI\":\"http://www.360doc.com/content/18/0414/16/5784427_745601385.shtml\",\"WARC-Payload-Digest\":\"sha1:SVH5LNUG5LY5AQ26CZG3L35LPYHW6LXV\",\"WARC-Block-Digest\":\"sha1:52SH3TPRMRZXCC5WT6RYKOYEJC3HVKOO\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-40/CC-MAIN-2022-40_segments_1664030334987.39_warc_CC-MAIN-20220927033539-20220927063539-00594.warc.gz\"}"}