Ultraboost
New Member
- Joined
- Mar 30, 2019
- Messages
- 3
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20/10/2015[/TD]
[TD]10.5[/TD]
[TD]19/10/2016[/TD]
[TD]8[/TD]
[TD]20/10/2018[/TD]
[TD]8.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]30/1/2016[/TD]
[TD]9.5[/TD]
[TD]20/3/2017[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/2/2010[/TD]
[TD]7.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hello, I am trying to find the latest result of a blood test. I have two repeating columns in the data - the Follow up date and then the result (stretching for 10ish columns). I want to start the result to show the number in the latest column e.g. F2 and if blank, go to D2 and return the latest result AND the corresponding date at an adjacent column (otherwise I won't have any idea which date it is from).
Is there a way to actually do this in the normal excel or do I need to 'make' some tools? I am a beginner but an eager learner.
Thanks
<tbody>[TR]
[TD]1[/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20/10/2015[/TD]
[TD]10.5[/TD]
[TD]19/10/2016[/TD]
[TD]8[/TD]
[TD]20/10/2018[/TD]
[TD]8.2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]30/1/2016[/TD]
[TD]9.5[/TD]
[TD]20/3/2017[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]10/2/2010[/TD]
[TD]7.4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hello, I am trying to find the latest result of a blood test. I have two repeating columns in the data - the Follow up date and then the result (stretching for 10ish columns). I want to start the result to show the number in the latest column e.g. F2 and if blank, go to D2 and return the latest result AND the corresponding date at an adjacent column (otherwise I won't have any idea which date it is from).
Is there a way to actually do this in the normal excel or do I need to 'make' some tools? I am a beginner but an eager learner.
Thanks