Hello,
This is the first time that I post here on this board with an Excel problem.
I have the next problem where I search for a solution
And so on; the idea is to get the FatherID and MotherID from a database on a separate worksheet. A person have a father and a mother. No 2 is the father of No 1 and No 3 is the mother of number 1 and so on.
Manualy is it with the function =D3 / =D4, =E3 / =E4 and futher but when a copy the formulas with the mouse in the selection to under than is not correct.
Is there a easier way to copy the data into the column ID from the row because a have a database of more than 2000 persons.
Hopefully you understand the problem and you can help me.
Screenshot:
This is the first time that I post here on this board with an Excel problem.
I have the next problem where I search for a solution
Code:
No ID FatherID MotherID
1 1037 2 104
2 2 135 250
3 104
4 135And so on; the idea is to get the FatherID and MotherID from a database on a separate worksheet. A person have a father and a mother. No 2 is the father of No 1 and No 3 is the mother of number 1 and so on.
Manualy is it with the function =D3 / =D4, =E3 / =E4 and futher but when a copy the formulas with the mouse in the selection to under than is not correct.
Is there a easier way to copy the data into the column ID from the row because a have a database of more than 2000 persons.
Hopefully you understand the problem and you can help me.
Screenshot:
