VBA Countif

[mrbob2]

Hi, Newbie here. thanks for making this possible. I have a data tester that test a pipe every ten minutes or so. The pressure starts off at -1 and goes up to 605 or so and holds for 5 seconds and then drops back down to 1 or -1. The program reader makes a .DAT file which i then export as a .CSV file.
The date and time are text. I used a countifs in excel and used the sort command to show me change of days. There is a 2018 when the day changes. The countifs worked beautiful except i have one problem. I used 600 as my count "600"
When the the pressure goes up like this- 600,601,603,604,605 then 603,602,600 or something like that. I count two 600's for one pipe not good. This changes my over all count.
I need to find a way to only count one data number at 600 or above for each test so i can get accurate number of test in the 24hr period.
I know that the dates being in text form does not help.
Thanks for your help.
Mrbob2

[6StringJazzer]

It would help immensely to provide an example of your data, with an example of what kind of result you want, and any VBA code you have. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Your description does not mention VBA, in spite of your title. How does VBA come into play here?

The description about COUNTIF and 600 is a bit of a red herring--it would be better to just state what you need to do rather than describe a method that you know doesn't work. It sounds like you are trying to count how many tests are performed in a given day.

Where do you want to show that count relative to your data?

Can a test start before midnight and then finish after midnight the next day? If so, is that test counted for the day it starts or the day it ends?

I would recommend a step where the date and time is converted from text to Excel date/time. That will make any other analysis of this data much easier.