Hi
I have a column of 2000 rows with numbers in them (no formulas)
I need to select numbers between 40 and 60 and for every one of those
numbers I need a " yes " in the same row but a different column , and
all other numbers under 40 and over 60 left blank
eg: A B
1 999
2 135
3 44 YES
4 60 YES
5 13
6 196
7 999
8 56 YES
9 48 YES
10 128
11 14
and so on

Is there any one that can help me ?

thanks in advance

bill


--
bill gras