+ Reply to Thread
Results 1 to 4 of 4

Do while loop without vba coding

  1. #1
    Registered User
    Join Date
    03-07-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Do while loop without vba coding

    Hi all,

    Attached a sample excel file and i know VBA programming can perform the task easily. I actually have used up the formulas countif and if to do it.

    Anyone can help to find solution if duplicate value more than 64?

    Best Regards
    Eric
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Do while loop without vba coding

    I think the TEXTJOIN function in Excel 2016 will do this, though I don't have it to test. Other than that, your approach, and a simple VBA UDF, I don't think you're going to find another alternative.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-07-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Do while loop without vba coding

    Dear shg,

    Thank for your advice, actually just wanted to join whatever data at Column B if Column A is the same.

    Best regards
    Eric

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Do while loop without vba coding

    Right. Same answer.

+ 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] How to loop in with VB Coding.
    By S.Daniel in forum Excel General
    Replies: 2
    Last Post: 09-05-2016, 03:01 PM
  2. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  3. Coding a Vlookup Loop
    By bakeraj256 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2014, 03:25 PM
  4. Problem with loop coding and formatting providing a #N/A error
    By Sue991 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-24-2012, 06:43 AM
  5. (Solve) How to add second loop in VBA coding
    By SubwAy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-04-2011, 03:30 PM
  6. Help in VBA Coding (DO WHILE / LOOP UNTIL) FUNCTION
    By gvreddyhr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2011, 03:05 AM
  7. [SOLVED] Cannot find inefficient coding loop
    By Trent in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2005, 10:05 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