Identifying changes in 2 data sets

[Slongy01]

Hi, I have two different dated Excel workbooks showing the same data time-stamped at two different points in time

I'm combining the data by stacking the latest version of the file underneath the previous

Each line has a the data date, a unique ID number, and an Owner (among other information)

All I need to do is to add a column to show me if the Owner in the first dated rows, matches the Owner in the second dated rows. If there's no match, I just need it to show that it changed

I would be so grateful if someone could point me in tthe right direction

Thank you

 

[JamesCanale]

One of these two aught to work for you.

MrExcelPlayground19.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Set 1				Set 2				Mismatches
2	Data Date	ID	Owner		Data Date	ID	Owner		Data Date	ID	Owner
3	7/14/2023	A	Fred		7/21/2023	A	Fred		7/14/2023	C	Mary
4	7/14/2023	B	Harry		7/21/2023	B	Harry		7/21/2023	C	James
5	7/14/2023	C	Mary		7/21/2023	C	James		7/21/2023	F	Frodo
6	7/14/2023	D	Sally		7/21/2023	D	Sally
7	7/14/2023	E	Fred		7/21/2023	E	Fred
8					7/21/2023	F	Frodo
9
10
11
12
13
14	Data Date	ID	Owner		Mismatches
15	7/14/2023	A	Fred		Data Date	ID	Owner
16	7/14/2023	B	Harry		7/14/2023	C	Mary
17	7/14/2023	C	Mary		7/21/2023	C	James
18	7/14/2023	D	Sally		7/21/2023	F	Frodo
19	7/14/2023	E	Fred
20	7/21/2023	A	Fred
21	7/21/2023	B	Harry
22	7/21/2023	C	James
23	7/21/2023	D	Sally
24	7/21/2023	E	Fred
25	7/21/2023	F	Frodo
Sheet7

Cell Formulas
Range	Formula
I3:K5	I3	=LET(a,VSTACK(Table3,Table4),b,UNIQUE(DROP(a,,1),,TRUE),c,XLOOKUP(DROP(b,,-1)&DROP(b,,1),TAKE(DROP(a,,1),,1)&TAKE(a,,-1),TAKE(a,,1),"",0),HSTACK(c,b))
E16:G18	E16	=LET(a,Table5,b,UNIQUE(DROP(a,,1),,TRUE),c,XLOOKUP(DROP(b,,-1)&DROP(b,,1),TAKE(DROP(a,,1),,1)&TAKE(a,,-1),TAKE(a,,1),"",0),HSTACK(c,b))
Dynamic array formulas.