Search for Values that meet a Criteria and Paste Location in a New Sheet

Try

Please Login or Register  to view this content.

Hello jindon,

That is exactly what I was looking for, however I still have a question which was not mentioned in the beginning.
Is it possible to have a comparison reference (an average value) for every line?
What I would like to get is the Name of the Panels and the Date/Time for those that were below 25% of the average value of each line.

Attached you can find the file with the average at the end of each line.

Thank you very much again jindon, I am trying to understand and interpretate the Code as I use it.

Hello Roger,

It is good to know also how to do it without VBA, I am giving it a try now. However as final solution I will rather utilize VBA because the Intention is for the End Users to have as less Access to the Information as possible.
The good Thing is I learned something new today!

Jorge

In that case, row 6 is the one below 2.5, Date/Time = 2017/9/2 19:00, what comes to the Panel name in the result?

jindon,

I did not understand the question, I am sorry.

OK, what do you expect for the result from then data in Results for Current?

Panel Name Date and Time

in Not Working Panels sheet.

Can you just show me the result that you want?

I just don't understand how exactly you want the result, specially col.A(Panel Name) in the result.

I did it manually and you can see it in the file again.

Each line has to have an average at the end.

If the value in a line is smaller than 25% of the average of its corresponding line (I marked the values that fulfill this condition in red), then show in a new sheet the Panel Name and Date/Time that corresponds to that value.

For example:
if the value is in C2, then the Panel Name will be C1 and the Date/Time A1.
if the value is in D3, then the Panel Name will be D1 and the Date/Time A3.
if the value is in B6, then the Panel Name will be B1 and the Date/Time A6.

I hope it is more clear now.

OK, do you need Average & 25% Average columns?
Anyway the code calculates both and populate the results, so see attached.

Please Login or Register  to view this content.

Yes, the ideal would be to have both the average of the line and also the 25% of that average, so the reference value can be seen.

I tried with the Code that you posted, however it does not seem to work properly, it always gives me the same three values on the "Not Working Panels" Sheet, regardless if there is even an average showed or not.

I am sorry to be such a pain, I am trying to be as clear as possible but also understand as much as I can from what you send me.

Can you upload a file that is not working properly?

It should work if you remove last 2 columns from Results for Current,

If you always have Average/25% Average columns, then change to

Please Login or Register  to view this content.

Note: Formula in you latest file in Average is wrong.

I tried it and works perfectly and does exactly what I needed.
I really appreciate your help, this will save tons of hours yearly.

Thank you!