Results 1 to 2 of 2

Thread: Programing problem

  1. #1

    Programing problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help to make the program (Not VBA -I do not know VBA)
    Table A1:A48 have variable numbers. These numbers can be from 0 to 15. Firs few of them, letís say 4, 2, 0,1,9,6.........................
    Table B1:B48 have the names in order (for now letís say A,B,C,D,E .............................)
    There is the table C1:AX2
    First row have ordinal numbers (from 1 to 48)
    Second row have letters A, B, C, D ... Order depend of numbers from column A 4, 2, 0,1,9,6.........................
    Number 4 is in front of A. Thatís mean in second row of the table C1:AX2 supposed to be four A's below numerical number 1,2,3,4
    After that, number 2 is in front of B. That mean below numerical number 5 will be B,
    In front of letter C is number 0. That mean letter C is not going to be in table C1:AX2, and so on.
    I spent two weeks trying and right now I don't even have idea what else to try.
    Can somebody help me?
    Thank you
    Regards
    Branko
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,087
    Articles
    79
    Blog Entries
    14
    Hi there, and welcome to the forum!

    I've moved your thread to the formulas forum since you aren't interested in a VBA solution.

    The attached isn't as elegant as some of our members would put together, but I think it will work provided that you don't have more than two consecutive 0's in your list. You'll need to modify the INDEX ranges to cover your whole table.

    Hope it helps,
    Attached Files Attached Files
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •