| Author |
 Topic  |
|
|
ticofiz
United Kingdom
21 Posts |
 Posted - 12/13/2016 : 11:20:44 PM
|
Origin Ver 9.1 and Service Release SR3 (Select Help-->About Origin):
Operating System:W7
Hello,
Could you please tell me how can I delete all the cells (not delete only the value but also the cell) in a Worksheet that contain numbers that are equal or less than a certain value? For example I want to remove all the cells that contain 0 or values less than 3.
Thank you,
Constantin |
|
|
AmandaLu
439 Posts |
Posted - 12/14/2016 : 03:24:15 AM
|
Hi,
Please try the following:
wcellsel rng:=1! cond:=lt v:=3; //select cells which value is less than 3
menu -e 36442; //delete the selected cells
Thanks,
Amanda
OriginLab Technical Service
|
 |
|
|
snowli
USA
1386 Posts |
Posted - 12/14/2016 : 09:43:11 AM
|
You can choose Edit: Find Replace... menu.
On Replace tab, set Data Type to Numeric, Condition to be <=0
Leave Replace with field black to remove all cells with value less than or equal to 0.
Thanks, Snow |
|
|
|
ticofiz
United Kingdom
21 Posts |
Posted - 12/14/2016 : 3:38:37 PM
|
AmandaLu, the command you suggested worked perfectly.
snowli, your suggestion works for deleting the value in the cell but not the cell itself. I needed to remove the cell so that the realigned rows contain the values that I am interested for.
Thank you both of you for your help. Originlab has a fantastic technical support.
Best wishes,
Constantin |
|
|
| |
Topic |
|
delete cells that contain certain values