Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Kim296

  1. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I have not worked with power query. Thank you so much for your time and suggestion.
  2. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you so much. This is way above my knowledge, but I would try to learn this method. I appreciate your time.
  3. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Wow, I didn't know this was a thing. Thank you so much for your response. Definitely above my knowledge, but I would love to try to learn this method.
  4. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I want to thank everyone for your suggestions. These are all excellent options for me to try. I appreciate everyone's time and expertise. Unfortunately, I feel as if EXCEL might not be a good option for this project as the file is becoming to large and running really slow. I may have to look at...
  5. Kim296

    ODBC vs ADO incorrectly defining fields

    Can you place the QR code directly onto the report? Or, does the QR change based on the type of field?
  6. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you very much for your time and suggestion. I am not very versed on VBA; I'm learning. I will try your suggestion today and see if I can figure it out. It looks pretty short and simple. Thank you again!
  7. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    No, I did reply. I would love to hear your suggestion on VBA. I haven't see the response. I will go back and look again. I'm sorry. I value everyone's time and responses.
  8. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I'm not familiar with Power query. This looks foreign to me, but I love a challenge. I will take this and try to learn what you are doing. Thank you so much for your time spent trying to help me find a solution. I really appreciate you!!
  9. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I definitely appreciate your time and response. I originally uploaded a few columns of my actual data in a screen shot, but it was confusing to the people trying to understand my question. So, I replaced it with sample data; hence, abc, bcd, etc.. After looking your suggestion in comparison to...
  10. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you for your response. I think this might work. Let me give it a go...
  11. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you for your reply.
  12. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    You're right. This is quite trivial for what I'm trying to accomplish. I've mulled this over for weeks. This is only one tab of a much larger workbook in which I've come to this point. This is a template in which new data (codes) will be introduced each time. There will never be one set of...
  13. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you for your reply.
  14. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Yes, that is correct. However there isn't one primary column to compare all to. I need to compare each of the 1,500 columns and extract "two or more" like codes from each columns independently of each other; hence, comparing all columns separately. See the screen shot I attached as an example...
  15. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you. Have a great trip!
See more

Part and Inventory Search

Back
Top