论坛 › 山东 › Excel教程：核对数据，这几个函数最好用！

6hz7vif 发表于 2024-10-2 17:05:15

Excel教程：核对数据，这几个函数最好用！

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">编按：</span></p>哈喽，<span style="color: black;">大众</span>好！<span style="color: black;">怎样</span>快速判断单元格字符<span style="color: black;">是不是</span><span style="color: black;">包括</span>数字和字母呢？在规范编码、<span style="color: black;">秘码</span>、用户名的时候，<span style="color: black;">咱们</span>经常要查证某一类字符串<span style="color: black;">是不是</span><span style="color: black;">包括</span>数字、英文、数字与英文的组合，<span style="color: black;">乃至</span>字符串的开头<span style="color: black;">是不是</span>是数字等。很简单，利用Code、Char、Find、Search文本函数搭配Count函数<span style="color: black;">就可</span><span style="color: black;">处理</span>这个问题。<span style="color: black;">另一</span>，关于转换字母<span style="color: black;">体积</span>写、删除字符前后两端的空格等，<span style="color: black;">咱们</span>今天<span style="color: black;">亦</span>会介绍。赶紧来<span style="color: black;">瞧瞧</span>吧！<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQ99pYqPFQagqpibYia03XYQ1jS0jvWOP4AqVNQCmM46hn4rxHGW3f8MVQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxZAP902kqL7wRke0cKLHSLvWnPKAIwSu2dh8u4EntIc9l0gdnXyj4xDjxb8icYsibLQYzZic32LTY2g/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">文本字符是Excel中除了数字以外的另一种非常常用的数据类型，Excel<span style="color: black;">亦</span><span style="color: black;">供给</span>了<span style="color: black;">海量</span>的文本函数。利用这些函数<span style="color: black;">咱们</span><span style="color: black;">能够</span>用来判断字符串开头<span style="color: black;">是不是</span>为数字、字符串<span style="color: black;">是不是</span><span style="color: black;">同期</span><span style="color: black;">包括</span>了数字和英文、字符串<span style="color: black;">是不是</span><span style="color: black;">包括</span>了指定字符，<span style="color: black;">能够</span>用来转换英文字母的大小，<span style="color: black;">能够</span>用来删除字符串前后空格。下面咱们<span style="color: black;">一块</span>来学习下。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">1.判断字符串开头<span style="color: black;">是不是</span>为数字</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">CODE()函数<span style="color: black;">能够</span>将Excel中任意字符串中的<span style="color: black;">第1</span>个字符转换为ANSI字符集中对应的数字代码，<span style="color: black;">而后</span><span style="color: black;">能够</span><span style="color: black;">经过</span>判断数字代码的<span style="color: black;">体积</span>，来判断字符的类型。CODE()函数的语法结构为：CODE(TEXT)，CODE()函数仅需要一个必选参数TEXT，该参数<span style="color: black;">表率</span>了要转换为数字代码的字符。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例子，某网站服务器数据变更，新服务<span style="color: black;">需求</span>会员名<span style="color: black;">不可</span>以数字开头，<span style="color: black;">倘若</span>会员是以数字开头，则会被打上无效标志“×”。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQzdjTOQk7jo1xKYSZjMoP3WMbxqs04mId7HibJO9mOGoYCvmJZUgribFA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">经过</span><span style="color: black;">查找</span>ANSI字符集可知，数字0-9对应的数字编码是48-57。会员名<span style="color: black;">需求</span><span style="color: black;">不可</span>以数字开头，<span style="color: black;">那样</span>只需要将会员名<span style="color: black;">叫作</span>的<span style="color: black;">第1</span>个字符转换为数字编码，只要这个数值在48-57之间，就被作上“×”标志。<span style="color: black;">能够</span>在C2单元格输入公式“=IF(AND(CODE(A2)&gt;=48,CODE(A2)&lt;=57),"×","")”，将公式向下填充到C23单元格，判断所有会员名<span style="color: black;">是不是</span>有效。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQkxo5rVkLGSNSwRsGD82XFc7EsvdCH3jyA4YYmf7J8Q7Nc2yCRWwLbg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">该公式<span style="color: black;">包括</span>了3个函数，其中最内层的CODE()函数用于返回字符串的数字编码。<span style="color: black;">这儿</span><span style="color: black;">咱们</span>直接将A2单元格<span style="color: black;">做为</span>其参数，<span style="color: black;">亦</span>能<span style="color: black;">得到</span>正确结果，<span style="color: black;">原由</span>在于当CODE()函数的text参数为一个字符串时，函数仅返回字符串中<span style="color: black;">第1</span>个字符的数字编码。</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">温馨提示</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">加入下面QQ群</span></strong><strong style="color: blue;"><span style="color: black;">：1043683754</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">下载教程配套的课件练习操作</span></strong></span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwhTOkH3Peu5jf8j1zyYJKNBD1clsic64kHta8l6SGxJIhPxpZp17ru4ozaL4aTduCPosePO2x7keQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">2.</span></strong><strong style="color: blue;"><span style="color: black;">随意转换字母的<span style="color: black;">体积</span>写</span></strong></span><span style="color: black;">英文字母有<span style="color: black;">体积</span>写之分，<span style="color: black;">倘若</span>要<span style="color: black;">经过</span>函数对英文字母的<span style="color: black;">体积</span>写进行转换，<span style="color: black;">能够</span><span style="color: black;">运用</span>UPPER()函数和LOWER()函数。</span><span style="color: black;"><span style="color: black;">倘若</span><span style="color: black;">需求</span>英文名<span style="color: black;">叫作</span>书写必须规范，如输入单词时，首字母需要大写，<span style="color: black;">能够</span>用PROPER()函数自动将小写的首字母转换为大写。以上三个函数均<span style="color: black;">包括</span>一个必选参数text，text<span style="color: black;">表率</span>要进行编辑的字符。<span style="color: black;">详细</span>功能如下：</span><span style="color: black;">ØUPPER()函数用于将给定字符串中所有英文小写转换为英文大写。</span><span style="color: black;">ØLOWER()函数用于将给定字符串中所有英文大写转换为英文小写。</span><span style="color: black;">ØPROPER()函数用于将小写字符的首字母转换为大写。<span style="color: black;">倘若</span>字符串不<span style="color: black;">包括</span>英文，不进行转换，<span style="color: black;">仅有</span>当字符串中<span style="color: black;">包括</span>英文单词，且单词首字母不是大写时，<span style="color: black;">才可</span>看到PROPER()函数的效果。</span><span style="color: black;"><span style="color: black;">经过</span>下面例子，<span style="color: black;">能够</span><span style="color: black;">容易</span><span style="color: black;">认识</span>三个函数的用法。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQwm73v9jMf2HP8mBJgKjOm2Ijamtgz3IPYFw9rPjDSUiaosEdCGGtF4w/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">3.字符串中<span style="color: black;">是不是</span><span style="color: black;">同期</span><span style="color: black;">包括</span>了数字和英文</span><span style="color: black;"><span style="color: black;">倘若</span>需要在一个文本中<span style="color: black;">查询</span>另一个文本的位置（区分字符的<span style="color: black;">体积</span>写），<span style="color: black;">那样</span><span style="color: black;">能够</span><span style="color: black;">运用</span>FIND()函数。</span><span style="color: black;">FIND()函数<span style="color: black;">能够</span>在指定的字符串中<span style="color: black;">查询</span>给定的字符（区分字符的<span style="color: black;">体积</span>写），并返回被<span style="color: black;">查询</span>字符在原字符串中首次<span style="color: black;">显现</span>的位置。FIND()函数的语法格式为：</span><span style="color: black;">FIND(find_text,within_text,)</span><span style="color: black;">从函数的语法格式中<span style="color: black;">能够</span>得知，FIND()函数<span style="color: black;">包括</span>两个必选参数find_text和within_text，以及一个可选参数start_num，各参数<span style="color: black;">道理</span>为：</span><span style="color: black;">Øfind_text：要在原字符串中<span style="color: black;">查询</span>的字符或字符串。</span><span style="color: black;">Øwithin_text：要在其中<span style="color: black;">查询</span>find_text字符串的原字符串。</span><span style="color: black;">Østart_num：指定要从within_text的第几个字符<span style="color: black;">起始</span><span style="color: black;">查询</span>，<span style="color: black;">倘若</span>省略此参数，则从<span style="color: black;">第1</span>个字符<span style="color: black;">起始</span><span style="color: black;">查询</span>。</span><span style="color: black;">举个例子，某网站的注册<span style="color: black;">秘码</span><span style="color: black;">最少</span>由字母和数字两部分<span style="color: black;">构成</span>，否则需要提示修改<span style="color: black;">秘码</span>。</span><span style="color: black;">分析思路：要判断<span style="color: black;">秘码</span>中<span style="color: black;">是不是</span><span style="color: black;">包括</span>数字和字母，就需要在原<span style="color: black;">秘码</span>字符串中分别<span style="color: black;">查询</span>数字和字母，<span style="color: black;">倘若</span>两者都能找到，<span style="color: black;">秘码</span>就<span style="color: black;">不消</span>更改，否则提示“请更改<span style="color: black;">秘码</span>”。要精确<span style="color: black;">查询</span>某个字符，<span style="color: black;">能够</span><span style="color: black;">运用</span>FIND()函数。<span style="color: black;">因为</span>需要<span style="color: black;">查询</span>字符串中<span style="color: black;">是不是</span><span style="color: black;">包括</span>数字和字母，<span style="color: black;">咱们</span><span style="color: black;">能够</span><span style="color: black;">运用</span>CHAR()函数结合ROW()函数生成要<span style="color: black;">查询</span>的字符，并对<span style="color: black;">查询</span>的结果进行统计。<span style="color: black;">倘若</span>找到，<span style="color: black;">那样</span>统计结果必定大于或等于1，若<span style="color: black;">无</span>找到，<span style="color: black;">那样</span>统计结果必定等于0。<span style="color: black;">经过</span>AND()函数将两次<span style="color: black;">查询</span>的结果进行结合，从而判断<span style="color: black;">秘码</span><span style="color: black;">是不是</span>需要修改。</span><span style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQYibRquTnnicdIf0ibQhfDTrbyCEtKnYBXZKo8vCvkMoqmgk785glibqGAA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><span style="color: black;">详细</span><span style="color: black;">过程</span>：</span><span style="color: black;">在E2单元格中输入数组公式“{=IF(AND(<span style="color: black;">COUNT(FIND(CHAR(ROW($48:$57)),C2))&gt;=1</span>,<span style="color: black;">COUNT(FIND(CHAR(ROW($65:$122)),C2))&gt;=1</span>),"","请更改<span style="color: black;">秘码</span>")}”，按“Ctrl+Shift+Enter”组合键结束数组公式。双击E2单元格右下角的自动填充柄，向下填充公式至E41单元格，判断其它用户的<span style="color: black;">秘码</span><span style="color: black;">是不是</span>需要修改。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQfcDa5M4eflAibfN2WVzUAR26a4Rv3S7sIQQSgAE7xOJI4LnEicE1ZeAQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">公式看似比较<span style="color: black;">繁杂</span>，但还是比较好理解的。<span style="color: black;">首要</span>公式<span style="color: black;">经过</span>“ROW($48:$57)”返回一个48-57的自然数序列，并用CHAR()函数返回该序列数字对应的字符，得到0-9的常量数组。<span style="color: black;">而后</span><span style="color: black;">经过</span>FIND()函数在C2单元格中分别<span style="color: black;">查询</span>0-9的数字，并生成一个数组，当C2中不<span style="color: black;">包括</span><span style="color: black;">查询</span>的数字，会产生#VALUE!错误，再用COUNT()函数对这个数组进行统计，计算其中非错误值的个数，最后判断结果<span style="color: black;">是不是</span>大于等于1。这<span style="color: black;">便是</span>公式红色部分的内容，蓝色部分与其大致相同，只是后部分用“CHAR(ROW($65:$122))”返回<span style="color: black;">包括</span>所有英文字母和部分符号的数组。当AND()函数的两个部分都返回TURE时，<span style="color: black;">经过</span>IF()函数返回一个空值，否则返回文本“请更改<span style="color: black;">秘码</span>”。</p>
    </span><span style="color: black;"><span style="color: black;">4.字符串中<span style="color: black;">是不是</span><span style="color: black;">包括</span>了指定字符</span>&nbsp;</span><span style="color: black;">SEARCH()函数<span style="color: black;">能够</span>在指定的字符串中<span style="color: black;">查询</span>给定的字符（<strong style="color: blue;">不</strong>区分字符的<span style="color: black;">体积</span>写），并返回被<span style="color: black;">查询</span>字符在原字符串中首次<span style="color: black;">显现</span>的位置。SEARCH()函数的语法格式为：</span><span style="color: black;">SEARCH(find_text,within_text,)</span><span style="color: black;">从函数的语法格式中，SEARCH()函数<span style="color: black;">包括</span>两个必选参数find_text和within_text,以及一个可选参数start_num，各参数<span style="color: black;">道理</span>和FIND函数相同。</span><span style="color: black;">SEARCH()函数在<span style="color: black;">查询</span>字符串的过程中，不会区分英文字符的<span style="color: black;">体积</span>写，并且在find_text参数中，还<span style="color: black;">能够</span><span style="color: black;">运用</span>通配符问号“？”和星号“*”，其中问号<span style="color: black;">表率</span>任意一个字符，星号<span style="color: black;">表率</span>任意多个字符。<span style="color: black;">倘若</span>要<span style="color: black;">查询</span><span style="color: black;">实质</span>的问号和星号，则需要在该字符前键入波形符“~”。</span><span style="color: black;">举个例子，某<span style="color: black;">机构</span><span style="color: black;">此刻</span>要统计出<span style="color: black;">善于</span>PPT的员工数量，<span style="color: black;">因为</span>员工的书写不规范（同一单词有大写<span style="color: black;">亦</span>有小写），并都在同一个单元格中，<span style="color: black;">咱们</span><span style="color: black;">能够</span>用SEARCH()函数进行<span style="color: black;">查询</span>，将<span style="color: black;">查询</span>的结果分配到一个数组中，再统计此数组中非错误值的数量。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQ6pVxfBHAgM9Xa2KAYwCFIzP3TFlyB9ria15ZlsexhVIoVFzt9sSTZ1Q/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">详细</span><span style="color: black;">过程</span>：在H1单元格输入数组公式“{=COUNT(SEARCH(F1,C2:C41))}”，按“Ctrl+Shift+Enter”组合键结束数组公式。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQdPMBrqlFl1gCArjhiaOM3Cpv3BjxuQ7eKYoYW3XejZdDXNn7s9DfjaA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">“SEARCH(F1,C2:C41)”部分<span style="color: black;">暗示</span>在“C2:C41”单元格区域中搜索F1单元格的值，<span style="color: black;">倘若</span>找到，会返回一个数值，否则返回错误值，即得到一个由数字和错误值<span style="color: black;">构成</span>的数组，最后<span style="color: black;">运用</span>COUNT()函数对此数组中非错误值进行统计，得到所需结果。</span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">5.</span></strong><strong style="color: blue;"><span style="color: black;">删除文本中前后两端的空格</span></strong></span><span style="color: black;">某些字符串中可能<span style="color: black;">包括</span>有不需要的空格，为了字符串的精确性，<span style="color: black;">能够</span><span style="color: black;">经过</span>TRIM()函数将其删除。该函数语法结构为TRIM(text)，text<span style="color: black;">暗示</span>要处理的文本字符串。</span><span style="color: black;">例如从网站导入的日期数据中<span style="color: black;">包括</span>空格，EXCEL就会自动将日期识别为文本，此时<span style="color: black;">能够</span>通过TRIM()函数进行处理。</span><span style="color: black;"><span style="color: black;">因为</span>下图中A列的日期前面<span style="color: black;">包括</span>空格，<span style="color: black;">引起</span>EXCEL<span style="color: black;">不可</span>正确识别，<span style="color: black;">咱们</span><span style="color: black;">能够</span>在B列<span style="color: black;">经过</span>TRIM()函数删除A列对应单元格字符串前的空格，并以乘1的形式将其转化为<span style="color: black;">表率</span>日期的序列，将该区域设置为日期类型<span style="color: black;">就可</span>正确<span style="color: black;">表示</span>。</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMwRLRI5AbpSkRdEVb0iaO0XQmozIXCNc2GOX3UYXMyLFE4X9k3LuCVW9O67H3eu5lgWUAGn7LXGFicA/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">最后，<span style="color: black;">咱们</span>再巩固下，找出字符对应的数字编码用CODE()函数，随意转换字母的<span style="color: black;">体积</span>写用UPPER()、LOWER()和PROPER()函数，<span style="color: black;">查询</span>文本的位置用FIND()、SEARCH()函数，删除文本前后两端的空格用TRIM()函数，<span style="color: black;">经过</span>这些函数您<span style="color: black;">把握</span>了字符串的<span style="color: black;">奥密</span>没？当然了，文本函数还有<span style="color: black;">非常多</span>，春风在<span style="color: black;">这儿</span>只是抛砖引玉，小伙伴们，还有别的什么想法，欢迎留言。</span>扫一扫添加老师<span style="color: black;">微X</span>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxrnjiblvzCzF6LUwqChME9wmz0kO0icibNsPJcnIPUWIyhw6KqYDztqmjvlM2tLKDUMob9o6oj7Kwww/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">在线咨询Excel课程</span></p><img src="https://mmbiz.qpic.cn/mmbiz_png/b96CibCt70iabwjyojLhA03PtxUnkNPREnYMIXQoTgtW6libdMibQVNic3eZhU08VyWfSQWdI82zIYSzSTq4Y3YV9nQ/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;">
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Excel教程<span style="color: black;">关联</span><span style="color: black;">举荐</span></strong></p><a style="color: black;"><span style="color: black;">Excel教程：快速统计带单位的数据，就这么干！</span></a><a style="color: black;"><span style="color: black;">Excel教程：急！我的筛选按钮用不了，怎么办？</span></a><a style="color: black;"><span style="color: black;">Excel教程：导出excel中的3000张<span style="color: black;">照片</span>，我只花几秒钟！</span></a><strong style="color: blue;"><span style="color: black;"><span style="color: black;">倘若</span>你想学精通Excel函数公式，不妨关注部落窝教育出品的《带你学透Excel函数公式》视频课程。</span></strong>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">《带你学透Excel函数公式》</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">包括</span></span><span style="color: black;"><strong style="color: blue;">89</strong></span><span style="color: black;">个工作最最常用的Excel函数</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">永久观看，配套练习课件</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">老师<span style="color: black;">每日</span>在线辅导答疑</span></strong></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">关闭</div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">观看<span style="color: black;">更加多</span></strong></div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">更加多</span></div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">退出全屏</div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">
                            <div style="color: black; text-align: left; margin-bottom: 10px;">
                              <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">视频加载失败，请刷新页面再试</p><a style="color: black;"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACIAAAAqCAMAAADhynmdAAAAQlBMVEUAAACcnJycnJycnJyoqKicnJycnJycnJycnJycnJyfn5+cnJydnZ2enp6kpKSdnZ2cnJyenp6cnJycnJycnJybm5t8KrXMAAAAFXRSTlMAyeb3CNp3tJRvHIEtJhBgqztWRJ+p5TqGAAABCklEQVQ4y5WTi27DIAxFAUMhgTzX8/+/urB2pdKI0x0pSoRuruyLbf7gF3PBaDE6X44LyY0D1SJQsfd9PpMM/CJx60v8SmV1HMSi1lKyA1n0jnwWSO08l04uJbxpBmTrpDtbGB6fmxC6Tc4BHv9aZDJdJsHW9w43Jez9x8T5M4l31WZsJn2bsYY+nUum2lQkGIVANPZ4FCLWOJImSTgjZE2SkU9crmu57mj9JBc93Qzj9R1d3HSG5bN5MRsnUzcGKK8Ns02z+Da7rYQE4bUE2PG1C6kVnkCyf0pwX8/jwbyxCLhcHpKTFkvkwK3pRmXtRrVFoTGYLvN+t0EUl0qrRaF1pFBz0anp/ptvNB4SY1XDAVMAAAAASUVORK5CYII=" style="width: 50%; margin-bottom: 20px;"> 刷新 </a>
                            </div><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADkAAAA5CAMAAAC7xnO3AAAAY1BMVEUAAAD///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////+aRQ2gAAAAIXRSTlMAOx20pMJbzBQNTDGTh2ohLCZmeUF2hEmXCFdxUquef4yHE17nAAACnklEQVRIx9WW2xqiIBSFRc1AUATJU1a+/1MOm0NYKvnNXM260ZLftRcbqCQinOLI0yiY/iXKuUZPjx5Fk+6RhF1yHiVF0wC6IZfr9fqIkpRqdNyQ9AoiUU8g+YZ8Xn96YmNKvkhkLMskKgEo/yJzaxkXeZsGsjeWKEIFU/FBZgA+D5yEwGtTgR0J18lYUvdcLZ1YkUjLf+a0saYYSG/J3Hury+WSkTCjCETtF6Mvd8QGJMZSWIfsAlKhWGRl5zQ1ZNBDgy/zzvvFavWUK7SyTRs+rsiUZS/4LHIHyo8VgBx7vDkKx2WhPS7dD1Q6cNlu2dTa0gMys4bz/vJR6ph8ADgcVcSVUkfnhzJTc6gRj8fbCOHk30UI2KC+V4gKjskJQqC5frFHli0kafogFIfFkAXVCSqdAFVR8pmtVCWiXCtaarbWpGtQAYx7sjf2GCbfjFRQpH7lTLucveSMBE7+Z6VqViT2/PVs0d7hPk9TUcTaUuVaT8k/f/v6SXOgyG7InZaSvM8vj/309LrbvpSAORDH2/kWGyHhm/u5AYUc8qdFBRRrsV749bRv6I5x1OY50GZUUxQz9aGplAXZcOQ1DL3vwsTyvHQ2YWgjZV2rDTmxYRjUuoBvcQDr7QRLBiiNzJ4BawG3FLtTmEMGBigTRyC2oIKht1vbwLWrKmXKBZal+yApDGhm4q5JCVdNdrZeQBe8B44WnE2NGmxrR1bCvMugHdkhSwMWI9wjIGeosnPlJmNrst6PQrpeFkBSyAmkdD016DYqAVC6HHcNtnCPgazcuytAd5IqB/qYtq4bkP7vnEaL3W4KH9/HhKBAKl8XFUlMIWYIek4hZgh6UtjHBLVA4pPkCKRf9jOQ5Kwp1UvPDyb3qkPJaRG8Ln7f8Q8Bki/Kj5IYnQAAAABJRU5ErkJggg==" style="width: 50%; margin-bottom: 20px;">
                        </div>
                  </div>
                </div>
            </div>
      </div>
    </div>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;"> <a style="color: black;"> 视频详情 </a> </div>
    </div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">小片段1</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">关闭</div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">观看<span style="color: black;">更加多</span></strong></div>
                        <div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">更加多</span></div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">退出全屏</div>
                  </div>
                </div>
            </div>
      </div>
      <div style="color: black; text-align: left; margin-bottom: 10px;">
            <div style="color: black; text-align: left; margin-bottom: 10px;">
                <div style="color: black; text-align: left; margin-bottom: 10px;">
                  <div style="color: black; text-align: left; margin-bottom: 10px;">
                        <div style="color: black; text-align: left; margin-bottom: 10px;">
                            <div style="color: black; text-align: left; margin-bottom: 10px;">
                              <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">视频加载失败，请刷新页面再试</p><a style="color: black;"><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACIAAAAqCAMAAADhynmdAAAAQlBMVEUAAACcnJycnJycnJyoqKicnJycnJycnJycnJycnJyfn5+cnJydnZ2enp6kpKSdnZ2cnJyenp6cnJycnJycnJybm5t8KrXMAAAAFXRSTlMAyeb3CNp3tJRvHIEtJhBgqztWRJ+p5TqGAAABCklEQVQ4y5WTi27DIAxFAUMhgTzX8/+/urB2pdKI0x0pSoRuruyLbf7gF3PBaDE6X44LyY0D1SJQsfd9PpMM/CJx60v8SmV1HMSi1lKyA1n0jnwWSO08l04uJbxpBmTrpDtbGB6fmxC6Tc4BHv9aZDJdJsHW9w43Jez9x8T5M4l31WZsJn2bsYY+nUum2lQkGIVANPZ4FCLWOJImSTgjZE2SkU9crmu57mj9JBc93Qzj9R1d3HSG5bN5MRsnUzcGKK8Ns02z+Da7rYQE4bUE2PG1C6kVnkCyf0pwX8/jwbyxCLhcHpKTFkvkwK3pRmXtRrVFoTGYLvN+t0EUl0qrRaF1pFBz0anp/ptvNB4SY1XDAVMAAAAASUVORK5CYII=" style="width: 50%; margin-bottom: 20px;"> 刷新 </a>
                            </div><img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADkAAAA5CAMAAAC7xnO3AAAAY1BMVEUAAAD///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////+aRQ2gAAAAIXRSTlMAOx20pMJbzBQNTDGTh2ohLCZmeUF2hEmXCFdxUquef4yHE17nAAACnklEQVRIx9WW2xqiIBSFRc1AUATJU1a+/1MOm0NYKvnNXM260ZLftRcbqCQinOLI0yiY/iXKuUZPjx5Fk+6RhF1yHiVF0wC6IZfr9fqIkpRqdNyQ9AoiUU8g+YZ8Xn96YmNKvkhkLMskKgEo/yJzaxkXeZsGsjeWKEIFU/FBZgA+D5yEwGtTgR0J18lYUvdcLZ1YkUjLf+a0saYYSG/J3Hury+WSkTCjCETtF6Mvd8QGJMZSWIfsAlKhWGRl5zQ1ZNBDgy/zzvvFavWUK7SyTRs+rsiUZS/4LHIHyo8VgBx7vDkKx2WhPS7dD1Q6cNlu2dTa0gMys4bz/vJR6ph8ADgcVcSVUkfnhzJTc6gRj8fbCOHk30UI2KC+V4gKjskJQqC5frFHli0kafogFIfFkAXVCSqdAFVR8pmtVCWiXCtaarbWpGtQAYx7sjf2GCbfjFRQpH7lTLucveSMBE7+Z6VqViT2/PVs0d7hPk9TUcTaUuVaT8k/f/v6SXOgyG7InZaSvM8vj/309LrbvpSAORDH2/kWGyHhm/u5AYUc8qdFBRRrsV749bRv6I5x1OY50GZUUxQz9aGplAXZcOQ1DL3vwsTyvHQ2YWgjZV2rDTmxYRjUuoBvcQDr7QRLBiiNzJ4BawG3FLtTmEMGBigTRyC2oIKht1vbwLWrKmXKBZal+yApDGhm4q5JCVdNdrZeQBe8B44WnE2NGmxrR1bCvMugHdkhSwMWI9wjIGeosnPlJmNrst6PQrpeFkBSyAmkdD016DYqAVC6HHcNtnCPgazcuytAd5IqB/qYtq4bkP7vnEaL3W4KH9/HhKBAKl8XFUlMIWYIek4hZgh6UtjHBLVA4pPkCKRf9jOQ5Kwp1UvPDyb3qkPJaRG8Ln7f8Q8Bki/Kj5IYnQAAAABJRU5ErkJggg==" style="width: 50%; margin-bottom: 20px;">
                        </div>
                  </div>
                </div>
            </div>
      </div>
    </div>
    <div style="color: black; text-align: left; margin-bottom: 10px;">
      <div style="color: black; text-align: left; margin-bottom: 10px;"> <a style="color: black;"> 视频详情 </a> </div>
    </div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">小片段2</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">《带你学透Excel函数公式》</span></strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">教育</span>目录如下：</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/AsZ6V72dHumelAk6T4e5BSTDl3jsRib3SW5NJvtzLTw6ZksJhia7h6pcSOu6kkBp6iclTphOiajkpcED1YrKzAQDHA/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1&amp;wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">限时特价</span><strong style="color: blue;">9<strong style="color: blue;">9</strong>元</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">（原价：<span style="color: black;">&nbsp;<strong style="color: blue;"><span style="color: black;">2</span></strong>99&nbsp;</span>元&nbsp;）</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">长按二维码购买</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">订阅须知</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、视频专栏，订阅成功后<span style="color: black;">就可</span><span style="color: black;">长时间</span>反复观看</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2、需要免费试听、领取课件等问题，请加客服<span style="color: black;">微X</span>：yangli952-</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">点“在看”给我一朵小黄花</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;">

nqkk58 发表于 2024-11-5 20:17:22

你的努力一定会被看见，相信自己，加油。

查看完整版本: Excel教程：核对数据，这几个函数最好用！