Deduplication based upon Date

[mawilson12]

I have a log file converted to Excel regarding software - name of computer, version of software and last date connected are the fields I am primarily interested in, but there are other fields with interesting info (like who is the person that was logged in)

Over a 30 day period, a machine could connect with version 100, and then 29 days later connect with a new version, say 101.
What I typically do is a deduplication of computer name, but that doesn't necessarily leave me with the latest date.
How are deduplications handled? If I sort according to date, will it to the first one or the 2nd one?
Or is there another way of handling this?

 

[kevin9999]

How are deduplications handled? If I sort according to date, will it to the first one or the 2nd one?

If you use the inbuilt functionality to remove duplicates, it will keep the first instance it finds (starting from the first row) and delete any subsequent duplicates based on the column you specify.

 

[Peter_SSs]

Or is there another way of handling this?

Kevin's information would mean you could sort by date (descending) & then Remove Duplicates.
Another possibility may be to leave the original data as is and use a formula like this to produce a separate list of the latest information for each name.

23 12 02.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Version	Date	Other 1	Other 2		Name	Version	Date	Other 1	Other 2
2	a	1	1/11/2023	1	9		b	1	19/11/2023	2	10
3	b	1	19/11/2023	2	10		d	1	21/11/2023	5	13
4	a	2	5/11/2023	3	11		a	3	6/11/2023	6	14
5	c	1	14/11/2023	4	12		c	2	21/11/2023	7	15
6	d	1	21/11/2023	5	13
7	a	3	6/11/2023	6	14
8	c	2	21/11/2023	7	15
9	c	2	16/11/2023	8	16
Latest

Cell Formulas
Range	Formula
G2:K5	G2	=FILTER(A2:E9,C2:C9=MAXIFS(C2:C9,A2:A9,A2:A9))
Dynamic array formulas.