| T O P I C R E V I E W |
| ticofiz |
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 |
| 3 L A T E S T R E P L I E S (Newest First) |
| ticofiz |
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 |
| snowli |
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 |
| AmandaLu |
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
|
