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

Kevin 杂记 1,514 次浏览 55条评论

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

下图示例有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

  29. #29

    20 mg cialis best price https://tadalafil.cleckleyfloors.com/

  30. #30

    viagra generic best price https://zsildenafil.com/

  31. #31

    cialis online pharmacy http://tadalafila.online/

  32. #32

    hydroxychloroquine still used for covid 19 https://hydroxychloroquine4u.com/

  33. #33

    if all webmasters and bloggers made just right content material as you probably did

  34. #34

    buy ivermectin without seeing doctor http://ivermmectin.com/

  35. #35

    Generally I don’t read post on blogs

  36. #36

    Thanks a lot for sharing this with all of us you really recognise what you are speaking about! Bookmarked. Kindly also talk over with my website =). We will have a link alternate arrangement among us

  37. #37

    vidalista without a doctor prescription http://vidallista.com/

  38. #38

    generic tadalafil vs tadalafil https://cialis360.jueriy.com/

  39. #39

    generic tadalafil vs tadalafil http://cialis.audiovideoninja.com/

  40. #40

    cheers

  41. #41

    First off I want to say wonderful blog! I had a quick question which I’d like to ask if you don’t mind.
    I was interested to know how you center yourself and clear your thoughts before
    writing. I’ve had a difficult time clearing my thoughts in getting my ideas out.

    I truly do take pleasure in writing but it just seems like the first 10 to 15 minutes are
    wasted just trying to figure out how to begin. Any
    ideas or tips? Thank you! http://cleckleyfloors.com/viagra

  42. #42

    Valuable info. Fortunate me I found your website by chance

  43. #43

    I have been browsing online greater than three hours nowadays, yet I never discovered any interesting article like yours.

    It is beautiful value sufficient for me. In my opinion, if all website owners and
    bloggers made good content as you did, the internet
    shall be much more helpful than ever before. https://cialis.grassfed.us/tadalafil

  44. #44

    who produces ivermectin https://ivermectin1st.com/

  45. #45

    What a stuff of un-ambiguity and preserveness of precious
    know-how regarding unexpected feelings. https://hydroxychloroquinea.advantagetriseal.com/

  46. #46

    Howdy I am so excited I found your web site, I really found you by
    accident, while I was browsing on Digg for something else, Regardless I am here now
    and would just like to say thank you for a incredible post
    and a all round entertaining blog (I also love the theme/design),
    I don’t have time to browse it all at the minute
    but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome work. https://cialis.webbfenix.com/tadalafil

  47. #47

    Great info. Lucky me I ran across your blog by accident
    (stumbleupon). I’ve bookmarked it for later! https://hydroxychloroquinec.cleckleyfloors.com/

  48. #48

    Good way of telling, and fastidious piece of writing
    to get facts on the topic of my presentation subject, which
    i am going to convey in school. http://www.deinformedvoters.org/aurogra-online

  49. #49

    Simply desire to say your article is as surprising. The clearness for your publish is just great and that i could suppose you’re an expert in this subject. Well along with your permission let me to grab your RSS feed to keep up to date with imminent post. Thanks a million and please continue the gratifying work.

  50. #50

    buy hydroxychloroquine online https://hydroxychloroquinex.com/

  51. #51

    My brother recommended I may like this blog.
    He was once totally right. This put up truly made my
    day. You can not believe just how much time I had spent for this information! Thank you!

    my blog; https://www.5ddiamondpainting.uk/cute-koala.html

  52. #52

    you could aid them greatly.

  53. #53

    What’s Going down i am new to this

  54. #54

    buy generic cialis online in usa cialis generic from canada cialis coupon 20mg http://www.tadalafill.online/

  55. #55

    When someone writes an post he/she retains the idea of a user in his/her brain that
    how a user can understand it. Therefore that’s why this paragraph is perfect.
    Thanks! https://cialis.cleckleyfloors.com/tadalafil

发表评论

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