• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Move data after conditional formatting and identification of duplicates

    Hi Narayan, I re-downloaded the example workbook and that eliminated the error. All is now working well. Thank you! Victoria
  2. V

    Move data after conditional formatting and identification of duplicates

    Hi Narayan, First, thank you VERY much for your help with this. I am finding I have much to learn about Excel. I did download the file and have tried to utilize it. I'm not sure what I am doing wrong but I keep receiving a VB error code 400. I believe I have both ranges defined...
  3. V

    Move data after conditional formatting and identification of duplicates

    Narayan, When I receive my data from my two different sources I sort each source independently before placing them side by side on my spreadsheet. I usually use alpha so therefore the names and numbers are matched (i.e. Jones 662 regarding your question above). Next I identify the matches...
  4. V

    Move data after conditional formatting and identification of duplicates

    Hi Narayan, I figured out the problem. The formula was returning FALSE because the data in each of my columns was stored as text (from the source) instead of numeric. Once I formatted the cells to numeric the formula returned a value of TRUE. Thank you very much for your help. Perhaps...
  5. V

    Move data after conditional formatting and identification of duplicates

    Hi Narayan, Yes, I want all LIKE entries to be side by side. Your example is exactly what I want. I manually go through the spreadsheet right now and insert rows to split the entries that do not have a match. 'Smith 420' as in your example would have no match to the left and 'Jones 662' would...
  6. V

    Move data after conditional formatting and identification of duplicates

    I used conditional formatting to identify duplicate data when comparing 4 columns. Now that I have the duplicates highlighted I want to be able to automatically align the data in my columns so that it is side by side. For example: Column A | Column B | Column C |...
Back
Top