Excel formula Take values from duplicate data RRS feed

  • Question

  • With the condition of column D, corresponding to column A, take out all the different values of column B, and display it in column E.
    Thursday, November 14, 2019 7:09 AM


All replies

  • Hi,

    Could you provide a sample about this problem?

    It's not very clearly about your requirement, please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.


    Emi Zhang

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, November 14, 2019 9:10 AM
  • This problem is fixed, thanks.

    • Marked as answer by GE_cnM Monday, November 18, 2019 1:28 AM
    Monday, November 18, 2019 1:28 AM