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
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    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

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- 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