Pick out highest maximum age for each individual and apply to previous height measurements

[helsbelz]

This is an example of my data, lets say they are heights of trees. The number is the tree individual, t2 is the age of the tree, height_t2 is the height of the tree at the age t2, and t_ current is the age of the tree individual at present/current. I would like a formula for the t_current column that will pick out the current age of the tree individual and apply it to the age years previous. i.e the t_current age should be repeated for each height measurement for that tree individual, i have filled it in as an example. Any help appreciated.

Number t2(age) Height_t2 t_current
1 1 23 6
1 2 48 6
1 3 70 6
1 4 83 6
1 5 92 6
1 6 100 6
2 1 28 6
2 2 49 6
2 3 65 6
2 4 84 6
2 5 92 6
2 6 98 6
3 1 22 6
3 2 42 6
3 3 63 6
3 4 80 6
3 5 91 6
3 6 98 6
4 1 32 4
4 2 53 4
4 3 69 4
4 4 84 4

[bebo021999]

Let's say range is A2:D23
In D2:
=MAX(IF($A$2:$A$23=A2,$B$2:$B$23))
Confirmed with Ctrl-shift-enter
Drag down

[helsbelz]

Hi, thank you for your response, this works in the separate sheet I used to make this example data set but in the original data set the relevant columns are not adjacent to each other, they are in fact columns J, M, O, and R. Is there a way of adjusting that formula to allow for this?

Thanks

[bebo021999]

Maybe:
=MAX(IF($J$2:$J$23=J2,$M$2:$M$23))