Hey guys I'm not that good at excel. Normally I can work around the formulas but this time it has not been working out.
I have two lists of ID which are very similar but yet not the same. Around 2200 values.
Example
ID1 ID2 Sex
1 1 Male
2 3 Female
3 4 Male
4 6 Female
6 7 Male
8 10 Female
The "Sex" is matched to ID2.
What I would like.
ID1 ID 2 Sex
1 1 Male
2
3 3 Female
4 4 Male
6 6 Female
7 Male
8
The IDs are arranged in ascending order but are not continuous.
Anyone knows what I can do?
I have two lists of ID which are very similar but yet not the same. Around 2200 values.
Example
ID1 ID2 Sex
1 1 Male
2 3 Female
3 4 Male
4 6 Female
6 7 Male
8 10 Female
The "Sex" is matched to ID2.
What I would like.
ID1 ID 2 Sex
1 1 Male
2
3 3 Female
4 4 Male
6 6 Female
7 Male
8
The IDs are arranged in ascending order but are not continuous.
Anyone knows what I can do?