I apologize the image I used was not visible but my 10 min edit time exceed so I am including more details on the issue in this post.
Hi,
I have an Excel spreadsheet that has 3 columns and thousands of rows.
The value in the third column indicates which row to copy. I am looking to copy the value from column A to column D if C has a value.
Then based off the number in C copy the value from A to E
If row 1 column C1 has a any value (greater 1 or greater) then D1 has the value of A1
Using the value in C1 it will determine which row to copy the value of column A from in the example row 1 below has a value of 1.
This would populate A1 into E1
Row 7 below C7 has a value of 4
This would cause D7 to be populated with the value from A7 (same as above)then using the value 4 go down to row 10
copy the value from A10 to E7
EXAMPLE:
A B C D E
| | | | | | |
2OPM0000002
| Y
| OPM0000002
| OPM0000002
| | | |
3OPM0000003
| Y
| OPM0000003
| OPM0000003
| | | |
4OPM0000004
| Y
| OPM0000004
| OPM0000004
| | | |
5 OPM0000005
| Y
| OPM0000005
| OPM0000005
| | | |
6 OPM0000006
| Y
| OPM0000006
| OPM0000006
| | | |
7 OPM0000007
| Y
| OPM0000007
| OPM0000010
| | | |
8 OPM0000008
| | | | | | |
9 OPM0000009
| | | | | | |
10OPM0000010
| | | | | | |
11OPM0000011
| Y | OPM0000011
| OPM0000012
| | | |
12OPM0000012
| | | | | | |
13OPM0000013
| Y | OPM0000013
| OPM0000014
| | | |
14OPM0000014
| | | | | | |
15OPM0000015
| Y | OPM0000015
| OPM0000018
| | | |
16OPM0000016
| | | | | | |
17OPM0000017
| | | | | | |
18OPM0000018
| | | | | | |
19OPM0000019
| Y | OPM0000019
| OPM0000020
| | | |
<colgroup><col style="mso-width-source:userset;mso-width-alt:3145;width:65pt" width="86"> <col style="mso-width-source:userset;mso-width-alt:585;width:12pt" width="16"> <col style="mso-width-source:userset;mso-width-alt:1024;width:21pt" width="28"> <col style="mso-width-source:userset;mso-width-alt:3145; width:65pt" span="2" width="86"> <col style="width:48pt" span="2" width="64"> </colgroup><tbody>
[TD="width: 86"]1OPM0000001
[/TD]
[TD="width: 16"] Y
[/TD]
[TD="width: 28, align: right"]1[/TD]
[TD="width: 86"] OPM0000001
[/TD]
[TD="width: 86"] OPM0000001
[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]2[/TD]
</tbody>
I know it is a simple one, but the options I have tried are simply not giving me the results. Any help will be appreciated.
Thanks,
Eric
