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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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!
  16. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I didn't use VBA (because I'm not that versed on it) but your Row, Column and Value method is how I located all the duplicates between sets. I just don't know how to query through them to determine if "two or more" [unknown] values are the same between sets. Do you know of a resource that I can...
  17. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    Thank you so much for your response. Every code listed (all 1,500 columns) is a duplicated, so it wouldn't do me any good to highlight the duplicate data. Every code would be highlighted. What I'm looking for is a solution to determine if there are two or more like values (from one column) that...
  18. Kim296

    Need Genius Help - Finding multiple duplicates between columns - EXCEL

    I really need some help from a genius. I'm working on a dynamic excel spreadsheet. There are over 1,500 columns with list data below each one. Does anyone know how I can dynamically find two or more like values that appear in any of the 1,500 columns. I don't just want to highlight duplicates. I...
  19. Kim296

    Sending Gmail using vba Send error

    Thank you for your time Andy, I tried the suggestion above. It still gives me the .send error. Hum, I will keep looking. Thank you.
  20. Kim296

    Sending Gmail using vba Send error

    Thank you for your response. Yes, I do have the Microsoft CDO library in my reference tools. The line of error is occurring from the "newmail.Send" line. This is what makes me think that I'm missing a step somewhere not relating to this code.

Part and Inventory Search

Back
Top