Finding occurences of a given value in a row

P

PhillyD

Hi, I have a spreadsheet with several columns where users input measurements.
I would like an automated means to check the entries for two seperate
conditions, first return all rows which contains a measurement between 1439mm
and 1449mm, second return all rows which contain a measurement equal or
greater than 1450mm. The difficulty is that it is possible that measurements
entered along the row may well meet both conditions. For values of less than
1439mm no return is necessary.

Many thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top