Hi, I,am new to this forum, Iam working in a project in wicth i
I want to look for a range of all the cells that contains the value of
"warm Up Time" and than find the Maximum and minimum from
that range.
Thanks
Hi, I,am new to this forum, Iam working in a project in wicth i
I want to look for a range of all the cells that contains the value of
"warm Up Time" and than find the Maximum and minimum from
that range.
Thanks
Please upload a sample workbook with the description and sample output. Thank you.
This is a partial copy of the woorksheet,
as a mention before what Iam trying to
acomplish is find the data for example
all the values "warm up Start" and
get the max and min for that value.
Hi,
Please see codes,
Please Login or Register to view this content.
Why do you even need a code for this task? A pivot Table
Or maybe, formulae?
Note that J4 is an array formula an must be confirmed with Ctrl+Shift+Enter not just enter, before dragging across to K4 and then down.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you all for replying,I tried Tangangtanga code but I notice that I needed to enter
the starting range in the example code in this case is B4. But, I not allways the starting point is
B4. Thats why I would like to do do search by Name in this case "Warm up Start" then
"Delivery 1" ect.ect. and if i find, for example delivery 1, I want to get the max and Min for
the range. In other words if the code finds the word "Warm up start" five times, I want
the max and min of that five reading.
I want to use vba since Iam more familiar the VBA than formulas.
Thanks again
Hello jotol,
This code might be closer to what you want to do using VBA. The entire worksheet is searched for the term "Warm Up Start" and the values from 2 columns to right of the cell are added to an array. After all cells have been searched, the minimum and maximum values are taken from the array and stored into 2 separate variables:Min and Max. A message box then dispalys the results. If no match is found, nothing will be displayed.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you Leith Roos the code works perfectly. This was what I was looking for.
Jotol
lol my bad, if only you briefly explained what you really need.I needed to enter
the starting range in the example code in this case is B4. But, I not allways the starting point is
B4. Thats why I would like to do do search by Name in this case "Warm up Start" then
"Delivery 1" ect.ect. and if i find, for example delivery 1, I want to get the max and Min for
the range. In other words if the code finds the word "Warm up start" five times, I want
the max and min of that five reading.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks