08-16-2013 09:29 AM
Hello,
I am attempting to delete the rows that are a multiples of the fundamental entry. However, the multiples of the fundamental are not always an exact multiple, they can differ by up to 3M. So, from the origial array,:
130.4M -65.386
149.4M 9.6346
172.2M -64.981
301.4M -17.273
426.8M -68.169
449.6M -820.72m
472.4M -66.132...
with the multiples of 149.4M deleted, the output array should be:
130.4M -65.386
172.2M-64.981
426.8M -98.169
472.4M -66.132...
Any help will be greatly appreciated!
Thanks,
hiNi.
08-16-2013 09:45 AM - edited 08-16-2013 09:49 AM
Hi,
this may work :
Here are the results :
I hope it will help
08-16-2013 09:53 AM
This?
08-16-2013 10:05 AM
In this solution, only half of the cases will be filtered.
For example, if the fundamental is 100, 101 will be filtered, but not 99.