I am trying to create a program for microsoft excel that allows users to type in what the need in two columns and returns those into headings in rows that the user specified. For example
Column1 Column2
a 2
b 4
c 1
d 2
etc. The user types in what the want in those columns and it appears in a row as
a a b b b b c d d
I am using the if function but I am limited by how many ifs I can use and it stops after the 5th row. I am using =IF(B2>=1,A2) for the first row, =IF(B2>=2,A2,IF(B2=1,A3)) for the second, =IF(B2>=3,A2,IF(B2=2,A3,IF(AND(B2=1,B3>=2),A3,A4))) for the third etc. Is there any other alternative or work around to get a longer list?
Bookmarks