i have coding like this
i want Take Unique in has Exists dictionary
for example in A1:A6 ={a,a,a,b,b,c}
i want only S = a,b
i has add code in d.exists(txt) but still doubel
Please Login or Register to view this content.
i have coding like this
i want Take Unique in has Exists dictionary
for example in A1:A6 ={a,a,a,b,b,c}
i want only S = a,b
i has add code in d.exists(txt) but still doubel
Please Login or Register to view this content.
Last edited by daboho; 10-03-2018 at 06:31 AM.
"ThankyouFor Attention * And Your Help!!"
Remove ElseIf part
Please Login or Register to view this content.
Last edited by jindon; 10-03-2018 at 06:33 AM.
jindon i want only if has exists data then i want take only unique
my problem is i have multi citeria (txt) ....
in want in second loop if not instr(txt(1),sn(i,1))=1 then
loop again ignore txt(1)
Ahh, then
Please Login or Register to view this content.
jindon this is my picture result i want
JINDON.png
this is my coding
AND THIS IS MY FILEPlease Login or Register to view this content.
I HAVE 120.000 ROW my data so big
Last edited by daboho; 10-03-2018 at 07:04 AM.
What are Criteria 1, Criteria 2 etc.
Your explanation is always confusing.
Just upload a workbook with the raw data and the result that you want clearly showing the logic behind it.
jindon this my criteria
txt(1) = sn(i, 1) & sn(i, 2) 'this key first loop
txt(2) = sn(i, 1) & sn(i, 3) 'this is second loop (in second loop if criteria meet but not include has show in txt(1) ,in my picture
post #5 col (6:8) in first criteria txt(1) = sn(i, 1) & sn(i, 2) result in first column is x,d
next key txt(2) i dont want result is x,d because has include in key txt(1)
although included and meet key txt(2)
i hope you understand i am sorri my english is bad
Still confusing.
What's your desired result?
You have duplicates in "your" result...
i am sorri if i has made you confusing but in my picture
this is i want,
second loop i am search duplikat value again using key = txt(2) = sn(i, 1) & sn(i, 3)
x b 1
x b 1
d 2 x
d 2 x
x,x,d,d show again if using key2 txt(2) = sn(i, 1) & sn(i, 3)
because x 1 and x 1 and d x and d x is duplikat if use txt(2) =sn(i,1) & sn(i,3)
i dont want if value has include in txt(1) = sn(i, 1) & sn(i, 2) show again in key(2)
i want remove that
result this only
f 3 2
f 4 2
f b 2
f 2 2
if meet key all entire row is showing
jindon2.png
Last edited by daboho; 10-03-2018 at 08:18 AM.
No, I don't understand.
Your result have duplicate rows, so wait for someone else who understands what you are trying to do.
this code has sukses but in result in sheet2 also include x,d
Please Login or Register to view this content.
jindon this is has sucsess but in large data is very slow to run
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks