+ Reply to Thread
Results 1 to 2 of 2

Looping through 2 cells, Concatenate the result

  1. #1
    Registered User
    Join Date
    12-27-2014
    Location
    Doha
    MS-Off Ver
    2011
    Posts
    5

    Looping through 2 cells, Concatenate the result

    Input1: 1 Input2: 5 Result = 1, 2, 3, 4, 5

    The user will give 2 inputs, in this case 1 and 5. On the same cell I want to loop and print the result as show 1, 2, 3, 4, 5.

    Input1: 2 Input2: 6 Result = 2, 3, 4, 5, 6

    is there any function that can give this result? I know how to do it with while loop in python and I am not sure if we have the same in excel. Thank you[table="width: 500"]
    Input1 Input2 Result/Function
    1 5 1, 2, 3, 4, 5
    2 6 2, 3, 4, 5, 6

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    19,767

    Re: Looping through 2 cells, Concatenate the result

    UDF

    Please Login or Register  to view this content.
    in C1

    =Listn (A1,B1)

+ 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. For-Looping with Range.Offset - Not Getting Expected Result
    By Maki in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-15-2015, 06:17 AM
  2. Looping through 2 different variable for different result
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-22-2014, 10:52 PM
  3. Concatenate with several criteria and looping
    By martinez77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-14-2013, 08:24 AM
  4. CONCATENATE Result
    By Koda7 in forum Excel General
    Replies: 2
    Last Post: 05-23-2011, 11:54 AM
  5. result of concatenate
    By Bakar in forum Excel General
    Replies: 2
    Last Post: 05-13-2011, 01:45 PM
  6. Looping using left function resulting in Concatenate
    By jaimie1664 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-12-2010, 08:12 AM
  7. Replies: 2
    Last Post: 04-12-2010, 12:35 PM

Tags for this Thread

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