range rwA=[%B]DATA_ALL!;
int numrowsA=rwA.maxRows;
range rwM=[%B]MERGE!;
int numrowsM=rwM.maxRows;
int match=0;
loop(ii,1,numrowsA)
	{
	match=0;
		loop(xx,1,numrowsM)
			{
				if([%B]DATA_ALL!Cell(ii,1) == [%B]MERGE!Cell(xx,1))
					match=1;
			};
		if(match == 1)
			{
				[%BnoGK]COMP!Cell(ii,1) = "";
				[%BnoGK]COMP!Cell(ii,2) = "";
				[%BnoGK]COMP!Cell(ii,3) = "";
			};
		else
			{
				[%BnoGK]COMP!Cell(ii,1) = [%B]DATA_ALL!Cell(ii,1);
				[%BnoGK]COMP!Cell(ii,2) = [%B]DATA_ALL!Cell(ii,2);
				[%BnoGK]COMP!Cell(ii,3) = [%B]DATA_ALL!Cell(ii,3);
			};
	};

range rwA1 = [%B]DATA_ALL!1;  // first column in data_all sheet
range rwM1 = [%B]MERGE!1;  // first column in merge sheet
dataset ds;  // dataset for holding the indices of all found elements
vfind ix:=rwM1 value:=rwA1[ii] ox:=ds;  // find elements whose values are equal to a specified value
if(ds.GetSize() > 0)  // if size of dataset is bigger than 0
	match=1;

quote:

---

Originally posted by Penn

Hi B.Przybyla,

You can try the vfind X-Function. And the second loop in your script can be replaced by using the following script.

range rwA1 = [%B]DATA_ALL!1;  // first column in data_all sheet
range rwM1 = [%B]MERGE!1;  // first column in merge sheet
dataset ds;  // dataset for holding the indices of all found elements
vfind ix:=rwM1 value:=rwA1[ii] ox:=ds;  // find elements whose values are equal to a specified value
if(ds.GetSize() > 0)  // if size of dataset is bigger than 0
	match=1;

Penn

---