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!

First condition use: IF(AND(A21439,A2<1449),A2,'') Type this in a helping
column
Second condition: IF(A2=1450,A2,"") Type this in another helping column
By comparing result of these helping columns you can find the difficulty you
mentioned.
--
R. Khoshravan
Please click "Yes" if it is helpful.
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!