Hi Team,
Column("A:B") is my Data, Column A Consist of Player Names.
I want to delete All player Excluding Player Names :=> {"Sachin,Dhoni,BretLee,Peterson"}
I want complete Row to delete .
How to achieve this task via dictionary or array. I know normal loop, trying to learn via Dictionary method.
Sample output shown in Column "F:G", output should remain in Column A and B.
Thanks in advance for help.
Below is my Sample Data.
Thanks
mg
Column("A:B") is my Data, Column A Consist of Player Names.
I want to delete All player Excluding Player Names :=> {"Sachin,Dhoni,BretLee,Peterson"}
I want complete Row to delete .
How to achieve this task via dictionary or array. I know normal loop, trying to learn via Dictionary method.
Sample output shown in Column "F:G", output should remain in Column A and B.
Thanks in advance for help.
Below is my Sample Data.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Player Name | Scores | Player Name | Scores | |||||
2 | Jaysurya | 13891 | Sachin | 19248 | |||||
3 | Dhoni | 8132 | Gayle | 12543 | |||||
4 | Sachin | 19248 | Peterson | 14824 | |||||
5 | Sehwag | 18357 | Sachin | 9387 | |||||
6 | Gayle | 12543 | Peterson | 9677 | |||||
7 | Peterson | 14824 | Sachin | 13700 | |||||
8 | Dhoni | 11927 | Peterson | 14992 | |||||
9 | David | 18854 | Sachin | 15534 | |||||
10 | Jaysurya | 19913 | Peterson | 12280 | |||||
11 | Sehwag | 12880 | BretLee | 8608 | |||||
12 | Sachin | 9387 | Sachin | 15975 | |||||
13 | Peterson | 9677 | BretLee | 19277 | |||||
14 | David | 16228 | Peterson | 15604 | |||||
15 | Sachin | 13700 | Sachin | 13626 | |||||
16 | Peterson | 14992 | BretLee | 12154 | |||||
17 | Sachin | 15534 | Peterson | 9257 | |||||
18 | Peterson | 12280 | BretLee | 18626 | |||||
19 | Dhoni | 12173 | BretLee | 17220 | |||||
20 | Sehwag | 11540 | Peterson | 15379 | |||||
21 | BretLee | 8608 | Sachin | 10339 | |||||
22 | Sehwag | 14310 | Sachin | 11329 | |||||
23 | David | 12559 | Peterson | 13656 | |||||
24 | Sachin | 15975 | Peterson | 19600 | |||||
25 | Dhoni | 16170 | Peterson | 16197 | |||||
26 | Jaysurya | 12763 | Peterson | 8324 | |||||
27 | Jaysurya | 13236 | BretLee | 16026 | |||||
28 | Jaysurya | 13260 | Peterson | 18839 | |||||
29 | BretLee | 19277 | Sachin | 14447 | |||||
30 | Peterson | 15604 | Sachin | 10515 | |||||
31 | Sachin | 13626 | Gayle | 8207 | |||||
32 | Dhoni | 15136 | Peterson | 12335 | |||||
33 | BretLee | 12154 | Gayle | 8530 | |||||
34 | Peterson | 9257 | BretLee | 14191 | |||||
35 | BretLee | 18626 | Gayle | 14427 | |||||
36 | Jaysurya | 17155 | Gayle | 10789 | |||||
37 | BretLee | 17220 | BretLee | 12489 | |||||
38 | Dhoni | 18238 | BretLee | 12719 | |||||
39 | Peterson | 15379 | Gayle | 15323 | |||||
40 | Sehwag | 17226 | Gayle | 11791 | |||||
41 | David | 12552 | Gayle | 17844 | |||||
42 | Sachin | 10339 | Sachin | 14703 | |||||
43 | Sachin | 11329 | Sachin | 15572 | |||||
44 | Peterson | 13656 | Peterson | 10172 | |||||
45 | Peterson | 19600 | Gayle | 8903 | |||||
46 | Sehwag | 10812 | BretLee | 12792 | |||||
47 | Jaysurya | 16750 | Peterson | 19201 | |||||
48 | Peterson | 16197 | BretLee | 18373 | |||||
49 | David | 14829 | Gayle | 8263 | |||||
50 | Peterson | 8324 | Peterson | 14352 | |||||
51 | Dhoni | 15639 | Sachin | 12931 | |||||
52 | BretLee | 16026 | BretLee | 12577 | |||||
53 | David | 18335 | Gayle | 16070 | |||||
54 | Peterson | 18839 | |||||||
55 | Sachin | 14447 | |||||||
56 | Sehwag | 18568 | |||||||
57 | Jaysurya | 9107 | |||||||
58 | Dhoni | 14731 | |||||||
59 | David | 11144 | |||||||
60 | Sachin | 10515 | |||||||
61 | Gayle | 8207 | |||||||
62 | Peterson | 12335 | |||||||
63 | Gayle | 8530 | |||||||
64 | BretLee | 14191 | |||||||
65 | David | 8131 | |||||||
66 | Dhoni | 10214 | |||||||
67 | Dhoni | 18809 | |||||||
68 | Dhoni | 12182 | |||||||
69 | Sehwag | 17764 | |||||||
70 | Jaysurya | 9374 | |||||||
71 | Jaysurya | 9715 | |||||||
72 | Gayle | 14427 | |||||||
73 | Gayle | 10789 | |||||||
74 | Dhoni | 18866 | |||||||
75 | David | 18572 | |||||||
76 | BretLee | 12489 | |||||||
77 | BretLee | 12719 | |||||||
78 | Jaysurya | 8902 | |||||||
79 | Gayle | 15323 | |||||||
80 | Gayle | 11791 | |||||||
81 | Dhoni | 12575 | |||||||
82 | Gayle | 17844 | |||||||
83 | Sachin | 14703 | |||||||
84 | Sachin | 15572 | |||||||
85 | Peterson | 10172 | |||||||
86 | Gayle | 8903 | |||||||
87 | BretLee | 12792 | |||||||
88 | Sehwag | 9806 | |||||||
89 | Peterson | 19201 | |||||||
90 | Dhoni | 13489 | |||||||
91 | BretLee | 18373 | |||||||
92 | Gayle | 8263 | |||||||
93 | David | 18320 | |||||||
94 | Dhoni | 15497 | |||||||
95 | Jaysurya | 18917 | |||||||
96 | Jaysurya | 8758 | |||||||
97 | Peterson | 14352 | |||||||
98 | Sachin | 12931 | |||||||
99 | BretLee | 12577 | |||||||
100 | Gayle | 16070 | |||||||
Sheet1 |
Thanks
mg