| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
some numbers to be blank
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding in multiple numbers when on cell is Blank | Excel Worksheet Functions | |||
| Change certain numbers & blank cells into a letter | Excel Discussion (Misc queries) | |||
| Sum groups of numbers in first blank cell | Excel Discussion (Misc queries) | |||
| Ghost numbers in blank cells | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
Threaded Mode
