Need to sort by latest or last value

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

See if this is what you want?

Your table...

	A	B	C	D
1	Product	Test	Product Version	Test Version
2	A	spark plugs	3	74
3	A	spark plugs	3	73
4	A	spark plugs	2	72
5	A	spark plugs	2	71
6	A	spark plugs	2	70
7	A	spark plugs	2	69
8	A	oil level	3	68
9	A	oil level	3	67
10	A	oil level	2	66
11	A	oil level	1	65

My summary table...

	F	G	H	I
1	Product	Test	Product Version	Test Version
2	A	spark plugs	3	74
3	A	oil level	3	68
4
5
6
7
8
9
10
11
12

F2=IF(G2="","",INDEX($A$2:$D$11,MATCH($G2,$B$2:$B$11,0),MATCH(F$1,$A$1:$D$1,0)))
G2=IFERROR(INDEX(B$2:B$11,MATCH(0,INDEX(COUNTIF(G$1:G1,B$2:B$11),),0)),"")
H2=IF(I2="","",INDEX($A$2:$D$11,MATCH($G2,$B$2:$B$11,0),MATCH(H$1,$A$1:$D$1,0)))
I2=IF(G2="","",MAX(IF($B$2:$B$11=G2,$D$2:$D$11,0)))
I2 is an ARRY formula, entered using CTRL SHIFT ENTER, not just enter
Then copy them all down