Please see attached Excel for example. I am trying to set up a program that if I have an input will select the correct results from the Data. In this case, If I use the input "1", I need a program that will go to the 1 column and copy over only the Values in Colume A that are True (T). The only way I know how to do it is a rather long way.
However in my real life case I have maybe 50 columns? Is there a more general way to write this program? Meaning I would need to do this for all 50 cases.Please Login or Register to view this content.
Thank you for any help!
Bookmarks