+ Reply to Thread
Results 1 to 3 of 3

Merge duplicate cells or Keep duplicates in one column if one of the rows has data

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Kosovo
    MS-Off Ver
    Excel 2010
    Posts
    2

    Merge duplicate cells or Keep duplicates in one column if one of the rows has data

    Dear all, am trying all day to find a solution by googling, didn't manage!?

    I have a huge document that looks like this

    Column A______Column B_____Column C
    100/12__________B___________$
    100/12______________________@
    100/12______________________€
    250/13______________________€
    250/13______________________$

    I want to keep in ColumnA all three rows of 100/12, because it has a value in Column B in one cell-which is the criteria, and remove the 250/13 because it has no value in cell B.

    I was assuming that merging duplicates in column A, and than remove empty from ColumnB, it will solve the problem, but i do't know how. Or any way, please help!?
    Last edited by Beckso; 04-07-2014 at 11:32 AM.

  2. #2
    Registered User
    Join Date
    04-07-2014
    Location
    Kosovo
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Merge duplicate cells or Keep duplicates in one column if one of the rows has data

    A sample of a document and how i want to look like.

    Please helppppppp
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-07-2014
    Location
    Kosovo
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Merge duplicate cells or Keep duplicates in one column if one of the rows has data

    Anyone please help:

    I want to keep in ColumnA all three rows of 100/12, because it has a value/data/text in Column B in one cell (which is the criteria), and remove the 250/13 because it has no value/Data in cell B of any row that 250/13 repeats.

+ 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] Remove rows based on duplicates in certain columns, and merge data from another column
    By yanagi600 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-02-2013, 04:17 PM
  2. Remove duplicates on column A and merge rows in column B
    By JJcool in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2012, 05:41 PM
  3. Replies: 11
    Last Post: 04-28-2011, 09:37 PM
  4. duplicate rows...merge cells
    By matinha052 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-20-2010, 07:40 AM
  5. Merge cells and remove duplicate rows
    By mbgritten in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-27-2009, 10:55 AM

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