Search code examples
google-sheetstimestampspreadsheetlibreoffice-calcdata-comparison

Comparing two different data with time stamp

I am facing a big problem with comparing two data. One reads me data with timestamp every 1 sec and another gives me data every 2 Sec. I am confused how could I compare both data by making the data aligned to their respective timestamp. Both are on different spreadsheets.

I tried to remove every alterative cells. But I have a load ton of data. Is there any way I could compare them

Image 1

1

Image 2

2

Solution

  • I don't know how you pretend to compare, but you can filter by odd or even number of rows. For example:

    =FILTER(A:Z,ISODD(ROW(A:A)))