Count number of days a threshold is exceeded

Hi, I have several years worth of data in two minute intervals and I want to count the number of days when a threshold value is exceeded. The format of the data is quite simple:

Column A: dd/mm/yy hh:mm (in two minute timesteps so 720 rows per day)
Column B: values

I simply want to count on how many days one or more values in column B exceed 2.5

Thanks

Hi,

Please upload a sample file.

Hopefully sample file attached with two consecutive days, one on which the threshold of 2.5 is not exceeded and one when it is, so the day count should be 1. I have years of data like this to look at.

Check the file with real data.

Awesome, thanks for your help.

You can now mark the thread as SOLVED and if you feel the solution helped you you may click the add reputation star below my comments.

You are Welcome!!!