I have a spreadsheet that has 133 columns that represent categories. On the row side I have about 1700 project numbers. Each project will use up to 14 of the 133 columns. The columns that are used with a project will have a cell labeled with a number 1. Example below:
Project No. Column B Column C Column D Column E.....Column DD
12345 1 1 1
What I need to do is find a function where I can retrieve "BCE" to indicate where data is stored in that row. I am looking for unique patterns and am using the column letters as a base. So I would really appreciate if anyone has any input. Thanks much.
Dick White
Colorado Springs, CO
Project No. Column B Column C Column D Column E.....Column DD
12345 1 1 1
What I need to do is find a function where I can retrieve "BCE" to indicate where data is stored in that row. I am looking for unique patterns and am using the column letters as a base. So I would really appreciate if anyone has any input. Thanks much.
Dick White
Colorado Springs, CO