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?
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,
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.