Need an if statement that looks at the next column after seeing an x in current column
Posted on 2013-01-24
I have a file with columns A through AQ. Each column has 51 rows. I am trying to transfer all of the information in across columns A through AQ, down column A.
I put an X in the 51st row of each column, but I can't figure out how to make a formula that reads the X and then goes to the top of the next column.