+ Reply to Thread
Results 1 to 5 of 5

Column duplicates - how to clear cell entries three columns to the right

  1. #1
    Registered User
    Join Date
    10-08-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Column duplicates - how to clear cell entries three columns to the right


  2. #2
    Registered User
    Join Date
    10-13-2013
    Location
    China
    MS-Off Ver
    Excel 2011
    Posts
    15

    Re: Column duplicates - how to clear cell entries three columns to the right

    Once you've highlighted the duplicate cells with a color (say yellow), then you could filter all the columns by the first column's color (filter by color). Then select the cells that are three columns to the right that you want to delete and delete them. Does that work for you?

  3. #3
    Registered User
    Join Date
    10-08-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Column duplicates - how to clear cell entries three columns to the right

    Yes that idea works but are you saying this task can be done automatically or manually?

    I have the duplicates in the first column (column A) highlighted in red already...I therefore need to automatically find all red entries in column A, then once a cell with red in it is found clear a cell on the same row but three columns to the right.

    So it's this last bit that I don't know how to approach - any top tips?!

  4. #4
    Registered User
    Join Date
    10-13-2013
    Location
    China
    MS-Off Ver
    Excel 2011
    Posts
    15

    Re: Column duplicates - how to clear cell entries three columns to the right

    This task is done manually. Let's say that the three columns you are working with are titled with the top cell of each column being Alpha, Bravo and Charlie (respectively from left to right). Select those three top cells (Alpha, Bravo and Charlie). Then, go to Data-->Filter. Once you choose filter (sometimes it is called Filter and Sort) this should bring up buttons on each cell (Alpha, Bravo and Charlie). Click on the Alpha button and there should be some options to filter by different criteria. Filter by color and you should get all of those red cells to come to the top with the corresponding content in columns Bravo and Charlie staying in line with where the Alpha content moved.

    Let me know if that works for you, otherwise I can try explaining it again or putting a sample spreadsheet up as an example.

  5. #5
    Registered User
    Join Date
    10-08-2009
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    26

    Re: Column duplicates - how to clear cell entries three columns to the right

    Many thanks...that manual method works - it's a shame it can't be done with a macro, but for now I'll use the manual method :-)

+ 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] Removing Duplicates Entries from each column with a for loop.
    By TonyM-2010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2013, 10:28 AM
  2. [SOLVED] Clear cell contents of duplicates within column
    By davegscott in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-12-2012, 06:26 PM
  3. Clear Duplicates in Column A to Z
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-19-2012, 04:47 AM
  4. Find duplicates in a column and conditionally clear the data
    By kiran234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2011, 05:38 PM
  5. [SOLVED] Excel: Clear all cell entries EXCEPT formulas?
    By newsgal in forum Excel General
    Replies: 6
    Last Post: 03-17-2006, 08:50 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