×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Finding and grouping values within a range

Finding and grouping values within a range

Finding and grouping values within a range

(OP)
I am having some trouble identifying the function or the method that I need to use to go about my issue.

I have exported a bunch of data into excel showing the data & time, pressure and flowrate. What I want to do is be able to identify atleast one hour periods of time that have a relatively constant pressure (i.e. a range withing -/+ 5 psi) and see what the flowrate during that period is. I have tried several excel functions such as Vlookup and match/indes, however, these are not powerful enough to do what I would like. I am having a hard time finding a function that can identify up to one hour blocks of time which also have a relatively constant pressure. I have a feeling this might require some VBA coding, however, I do not have any experience in VBA.

I have attached the spreadsheet containing the data I am working with to give you an idea of what I am talking about.

Your help is much appreciated.
 

RE: Finding and grouping values within a range

Graph it.

RE: Finding and grouping values within a range

(OP)
Thank you for the reply. I have graphed already graphed it and even though it does help identify regions of constant pressure, however, I don't want to go through the spreadsheet manually to find this as it is very time consuming but just have a function that can do it for me.

RE: Finding and grouping values within a range

the simplest method would be to have a column with an IF statement

CODE

=IF(AND(b2>=35,cell<=45),c2,"")
where column B is the data containing pressure, Col C contains flowrate, and the ideal pressure is 40 +/- 5 psi (35 & 45)

RE: Finding and grouping values within a range

seems like jghrist's solution has met all the requirements of the original poster.

=====================================
(2B)+(2B)'  ?

RE: Finding and grouping values within a range

(OP)
sorry about that, I thought I attached it.

jghirst your example helped me out a lot though, gives me a better idea of what to do. What do you think I could do in the case that the time intervals are not constant between subsequent pressure and flow measurements?

http://files.engineering.com/getfile.aspx?folder=48108067-de08-4270-a596-dbaaa866c341&file=pressure-flow.xlsx

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources