My data is currently located in two worksheets
In the first sheet is my collected data
In the second sheet is the information that I manually copy from the first sheet
In the first sheet the data I used are in two rows e.g.:
In the second sheet I need to record the information in separate columns as listed below
X= 73.85 ?=76.49
What I currently do is used the + and reference the cells in the first sheet.
What I would like to do in the second column (?) Is somehow write a formula that would look at what is in the first column (x) and give me the result of 76.49
Is there a way to do this?
In the first sheet is my collected data
In the second sheet is the information that I manually copy from the first sheet
73.85 |
76.49 |
In the second sheet I need to record the information in separate columns as listed below
[FONT="]AaAaAaA[/FONT] | X | [FONT="]BAaABbAB[/FONT] | [FONT="]?[/FONT] |
X= 73.85 ?=76.49
What I currently do is used the + and reference the cells in the first sheet.
What I would like to do in the second column (?) Is somehow write a formula that would look at what is in the first column (x) and give me the result of 76.49
Is there a way to do this?