+ Reply to Thread
Results 1 to 2 of 2

Duplicate values in column A -> print column B values to Column C (2nd edition)

  1. #1
    Registered User
    Join Date
    02-02-2021
    Location
    Finland
    MS-Off Ver
    Office365
    Posts
    6

    Duplicate values in column A -> print column B values to Column C (2nd edition)

    Hello again.

    I had quite a similar problem before and I found help from here. I tried to change the formula to work with my new situation but did not manage to do it.

    So I have duplicate values in column A and I would need to print corresponding cell B values to cell C. In the attached example I have written down manually the text in red and i am looking for a formula that could do it automatically.

    Thank you in advance for all those who helps because of good will!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-05-2019
    Location
    Tiki Island, TX
    MS-Off Ver
    Office 365
    Posts
    168

    Re: Duplicate values in column A -> print column B values to Column C (2nd edition)

    This formula should do it
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I was able to help you, you can thank me by clicking the Add Reputation button below and marking the thread Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Duplicate values in column A -> print column B values to Column C
    By K.Flaming in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-03-2021, 09:50 AM
  2. Replies: 7
    Last Post: 10-26-2020, 07:05 AM
  3. Producing duplicate values in Column A using Criteria from Column B
    By Tgandhi in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2020, 09:50 PM
  4. [SOLVED] Total values in one column based on duplicate copies in another column
    By grim72 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2018, 02:31 PM
  5. Remove rows with duplicate values in one column based on value of another column
    By jolleyje in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 06:20 AM
  6. Replies: 3
    Last Post: 02-12-2013, 03:09 PM
  7. Macro to Sum up values in column F, as per duplicate cells in column C
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2011, 06:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1