Programing problem

Joined
Apr 27, 2011
Messages
1
Reaction score
0
Points
0
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
 

Attachments

  • Radovan.xlsx
    9 KB · Views: 16

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
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,
 

Attachments

  • Radovan.xlsx
    9.5 KB · Views: 20
Top