Hi,

I have the following data in a spreadsheet: (note- I have also attached the spreadsheet to this post).

2015ID 2015Date 2015Type 2016ID 2016Date 2016Type
111 2/5/2014 E034 123 2/18/2014 E001
112 2/6/2014 E035 124 2/19/2014 E002
113 2/7/2014 E036 125 2/20/2014 E003


114 2/8/2014 E037 126 3/20/2014 E004
115 2/9/2014 E038 127 4/20/2014 E005
116 2/10/2014 E039 128 4/20/2015 E006
117 2/11/2014 E040 129 4/20/2016 E007
118 2/12/2014 E041 130 5/20/2016 E008
119 2/13/2014 E042 111 2/5/2014 E034
120 2/14/2014 E043 132 3/4/2014 E077


Is there a formula for where I can detect if 2015ID/Date/Type (all three listed across) are listed across, in order, in 2016ID/Date/Type? So example: the following values on the left (2015 data) in the first row are also listed in the columns on the left in row 10. Is there a formula that will allow for me to detect if data listed in the 2015 column is also listed in the 2016 column? My apologies if this was confusing, and thank you in advance!

Attached Files

Dummy Data.xlsx (13.4 KB, 10 views)

Maybe like the attached.

Attached Files

DummyData_2.xlsx (14.0 KB, 15 views)

Thanks, xor. I may be wrong, but it looks like the formula you used only identifies if the cells in A2:C2 are found in order in E2:G:11. Is there a way this formula can be expanded so that data in 3 horizontal, sequential cells found in A2:C11 that is duplicated in E2:G11 can be identified? Thanks for your help!

Could you please try to indicate manually in the file, the result you want?