PDA

View Full Version : Programing problem



brankoalpha@hotmail.com
2011-04-27, 02:38 AM
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

Ken Puls
2011-04-27, 05:20 AM
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,