0

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

vimuth
  • 5,064
  • 33
  • 79
  • 116
Sujith
  • 3
  • 2

1 Answers1

1

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)))
Martín
  • 7,849
  • 2
  • 3
  • 13
  • Thanks. That's a good way to find out, but is there a way where I can compare the time stamp of both sheets and match them and bring the data respectively? – Sujith Mar 21 '23 at 12:23
  • Yes, but you should define how you would match. In your second image, the measurements occur at irregular times. There are rows with consecutive seconds, but some with repeated "odd" values (that won't match exactly with your always "even" seconds from Image 1) – Martín Mar 21 '23 at 12:30
  • When there's not an exact match in times, should it take the next smaller or the next larger?, or not take any? – Martín Mar 21 '23 at 12:31