Excel里的相同内容以并行方式对齐查看

Kevin 杂记 1,057 次浏览 28条评论

当表格里有大量数据时,若要对比查看不同列里的相同内容,借此辅助其它数据整理。人工逐行检查不太现实,效率也很低,尤其遇到排序不同情况下更难处理。下面分享一个简单公式,可以很好解决这个问题。

下图示例有AB两列,这里希望B列里的数据对应于A列位置显示。

先在C1输入计算公式=IF(COUNTIF(B:B,A1),A1,""),然后点击C1下拉选定要计算的区域,这时C列会自动在对应位置显示B列数据。效果如下图。

Excel并行对齐查看相同内容

评论列表

  1. #1

    Hi, very nice website, cheers!
    ——————————————————
    Need cheap and reliable hosting? Our shared plans start at $10 for an year and VPS plans for $6/Mo.
    ——————————————————
    Check here: https://www.reliable-webhosting.com/

  2. #2

    https://ad4c572c222900.wifeosite.com/

  3. #3

    https://solarcore.nettiblogi.fi/2020/06/12/silver/

  4. #4

    https://plexuss.com/post/BOMWVYmxkaz4pvmdJ0PoX1G68

  5. #5

    http://morningworkers.simplesite.com/

  6. #6

    acyclovir 400 mg tabs https://www.herpessymptomsinmen.org/productacyclovir/

  7. #7

    bimatoprost generic best price https://carepro1st.com/

  8. #8

    who makes stromectol https://ivermectin.webbfenix.com/

  9. #9

    generic viagra cost at costco http://droga5.net/

  10. #10

    cialis 10mg tablets price http://www.lm360.us/

  11. #11

    hydroxychloroquine in south dakota https://hydroxychloroquine.mlsmalta.com/

  12. #12

    ivermectin dose for scabies adults https://ivermectin.mlsmalta.com/

  13. #13

    vidalista as needed dosage https://vidalista.mlsmalta.com/

  14. #14

    states not allowing hydroxychloroquine https://hydroxychloroquine.webbfenix.com/

  15. #15

    prices for generic vidalista https://vidalista40mg.mlsmalta.com/

  16. #16

    tadalafil for sale on ebay https://tadalafili.com/

  17. #17

    tadalafil tablets price in india https://wisig.org/

  18. #18

    albuterol for cats https://amstyles.com/

  19. #19

    which is best viagra or dapoxetine https://ddapoxetine.com/

  20. #20

    remdesivir cost per pill https://hydroxychloroquinee.com/

  21. #21

    what is prednisone used for https://bvsinfotech.com/

  22. #22

    when do you need vidalista http://viidalista.co/

  23. #23

    chloroquine use for covid 19 https://hydroxychloroquine.wisig.org/

  24. #24

    chloroquine use for covid 19 https://hydroxychloroquine.lm360.us/

  25. #25

    cenforce cost per pill http://cavalrymenforromney.com/

  26. #26

    generic prescription drug cheapest prices https://buymeds.mlsmalta.com/

  27. #27

    generic prescription drug cheapest prices https://medpills.bee-rich.com/

  28. #28

    Thanks a bunch for sharing this with alll folks you really know what you’re speaking
    about! Bookmarked. Kindly additionally visit my web site =).
    We cann have a hyperlink alternate contract between us

    Stop by my webpage … https://www.diamondpaintings.us/cat-uncle-5d-diy-paint-by-diamond-kit.html-1

发表评论

电邮地址用于 Gravatar 头像显示,不会被公开可见。