Find missing data in dataset

[RonanH]

Hi all,

I've downloaded a large dataset >1400 entries.

I know there's approximately 500 missing.

The data is weather from the NOAA and I was thinking of testing to see whether each row differed by the required 30minutes. (They are half-hourly figures) I haven't been able to test this correctly yet.

I've tried =IF(A2-A1=30,,"ERROR)

and the above with a reference to a cell with 00:30 in it rather than 30.

Any suggestions?

 

[kpark91]

=if(a2-a1 = 1/ 48, , "error")

 

[RonanH]

Doesn't seem to be working for me. I just keep getting error. Would it be something to do with the data types/formats in the original cells?

Thanks

 

[Ruddles]

Does column A really have times in it? If you create a formula =A1*2, what value does that return? (Tell us what's in A1 also.)

You might need to show us a few lines of the data to give us something to go on.