cool hit counter Five data-checking tricks that are fast and accurate Checking takes only seconds_Intefrankly

Five data-checking tricks that are fast and accurate Checking takes only seconds


Step: Select the target cell, enter the formula [=A2=B3], and drop down to fill. If the data content is the same show TRUE and vice versa show FALSE.

Two columns of data in Excel want to do a quick reconciliation? The 5 fastest and most complete methods are right here! And it's so easy to learn, you're guaranteed to know it in one look!

I. Shortcut key [Ctrl+]

Steps: select the target cell, press the [Ctrl +] shortcut key, not the same content quickly displayed, followed by a click on the color to mark it.

II. [=] equals sign

Step: Select the target cell, enter the formula [=A2=B3], and drop down to fill. If the data content is the same show TRUE and vice versa show FALSE.

Third, IF function

steps: Select the target cell, Enter the formula【=IF(A2=B2," properly"," mistakes")】 perhaps【=IF(COUNTIF(A2,B2)=1," properly"," mistakes")】, Just pull down and fill。 If the data content is the same the display is correct, Instead, an error is displayed。

Fourth, the EXACT function

Step: Select the target cell, enter the formula [=EXACT(A2,B2)], and drop down to fill. If the data content is the same show TRUE and vice versa show FALSE.

V. DELTA function

This function can only check the numbers, if the data content is the same display 1, and vice versa display 0.

Step: Select the target cell, enter the formula [=DELTA(A6,B6)] can be.

PS: If there is a problem with Excel file format conversion, whether it is converted to Word, PDF, PPT or pictures, you can use Xunjie PDF Converter to convert.


Recommended>>
1、Is it really so easy to find a job in the AI industry for a recent PhD earning 800000 a year
2、Lingbao City Audit Bureau Internet finance to mention the credit civilization unit to speak of integrity
3、Worried about vaccine safety Blockchain may be the answer to this problem
4、Apple macOS multiple apps collect user privacy says foreign media
5、Huawei chairman on cybersecurity the company has made cybersecurity and privacy protection its highest agenda

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号