Searching for specific values - filter doesn't work

[PhillyD]

Hi, I asked this question a few days ago but I didn't really get any reply I
could use, so in the hope someone understands my question, here goes:

I have a spreadsheet in to which users type measurements, each row being
related to one asset. However, throughout the length of the asset several
measurements are taken.

What I would like to do, is for each asset, look through the measurements
entered for that asset, some 8 columns which are incidentally not
consecutively laid out, and tell me the following three conditions:

1. any occurence of values between 1439 and 1449
2. any occurence of values greater than, or equal to, 1450
3. any occurence outside these values

Conditional formatting would be my starting point but if an asset passes on
the first column, how do I get Excel to check the remaining values entered
for that asset?

Thank you for your patience, help and understaning in advance.

Phil

 

[xlmate]

You should responded back to your post and tell why the formulas provided
doesn't
work for you. Nevertheless, try these, place these into 3 different cells

1) 1st condition : =IF(AND(A2>=1439,A2<=1449),A2,"outside this range")
2) 2nd condition : = IF(A2>=1450,A2,"this is <1450")

Having the above two formula, you actually don't need another formula for
your
3rd condition, but you need, try

3) 3rd condition : =IF(AND(A2>=1439,A2<=1449,A2>1450),A2,"check values")

Is this what you want? if not, post back with a sample of data table and
your expected result...all shown in the post for us to understand your
requirements.

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis

 

[PhillyD]

Franci,

Thank you for your reply. My apologies for not replying to the other thread
also. I have tried your formula but Excel will not allow me to enter it as
written in your reply but returns an error message. I have written it in to
the cell exactly as it appears in your reply but I changed the ref A2 to X2
as that is the first column with measurements in it. Columns X to AJ are the
columns I need to check for the values given, however, not all the columns
within that range need to be checked.

How do I post a sample of the spreadsheet?

Many thanks for your help.

Phil

 

[PhillyD]

Sincere apologies for posting this question 3 times - my PC kept saying that
there was an error and that the thread hadn't posted - plainly that was not
the case.

Apologies also Francis for dropping the 's' from your name - entirely
unintentional.

How do I delete the spurious threads please?

 

[Pete_UK]

You can't delete the threads.

One drawback with this multi-posting is that you now have replies at
your other threads, which you have to remember to check on. A
contributor will not necessarily read them in the order you post, and
so you will get multiple replies, some of which may be similar.

Pete

 

[PhillyD]

Thank you Pete.

I'm not sure why the system was telling me that my thread hadn't posted due
to an error then I find it has actually posted them.

Apologies again for inadvertently cluttering up the board.

Regards,

Phil

 

[Pete_UK]

Yes, but you still haven't answered my questions on your other thread.
If you do so then I can tell you what to do specifically for your
data.

Pete