Answer to Question #156687 in Management for Emily

Question

 Imagine you have received a spy’s spreadsheet that uses two columns of data, runs them through a formula, and then outputs the results in a third column. There are hundreds of thousands of rows of data, and the data consists of numbers between -500 and 1,000. The password to protect the cell is effectively unbreakable; it was never written down, was incredibly long, and no one alive today knows what it was. How might you go about figuring out the formula used for column C? 

Answer 1

The column number of cell C is given in the cell reference. For instance, the formula =Column(C10) returns 3, because column C is third column.