B
bill gras
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
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