Compare two different data tables and extract rows

I have two Excel file and also two different counter due to duplicate number. For example, Counter1 is 1,2,3,4,5; Counter2 is 1,2,2,3,4,5. Therefore, i wanna extract duplicate rows. Then, i would like to plot datas like plot(counter1,A1); hold on; plot(counter2,A2). My aim is display difference between 2 datas of excel files like plot(counter1,A-A). My problem is causing due to Data1 is receiving from sensor A, Data2 is receiving from sensor B.

Question: How can i match two counters? Note: For loop is take too long. I have more than 2.000.000.000 datas.

Answer 1

[Cris LaPierre]

I would use the unique function with the following syntax.

C = unique(A,___,'rows')

However, if you really have 2 billion rows, plan on any approach taking a while.

[BERK INAN]

I thanks a lot.

I solved this problem before you. I used unique function like you.

[C3,ia] = unique(Data1.counter1);

C4 = Data1(ia,:);