Hi all,
a lite problem for you:
How do I find and delete non duplicates value in column B?
A rule say that every value in B has a different value in C, so a duplicate has the same value in B but different in C.
thannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnks
a lite problem for you:
Cartel1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | bla | u | 1 | bla | ||
2 | 1 | blo | ||||
3 | 1 | bli | ||||
4 | blo | du | 2 | bla | ||
5 | 2 | blo | ||||
6 | 2 | bli | ||||
7 | 2 | bla | ||||
8 | 2 | blo | ||||
9 | bli | tri | 3 | bli | ||
10 | 3 | bla | ||||
11 | blu | quater | 4 | blo | ||
12 | 4 | bli | ||||
13 | ble | sic | 5 | bla | ||
14 | 5 | blo | ||||
15 | 5 | bli | ||||
16 | 5 | bla | ||||
17 | 5 | blo | ||||
18 | 5 | bli | ||||
19 | 5 | bla | ||||
20 | 5 | blo | ||||
21 | bly | ses | 6 | bli | ||
22 | 6 | bla | ||||
23 | 6 | blo | ||||
Foglio1 |
How do I find and delete non duplicates value in column B?
A rule say that every value in B has a different value in C, so a duplicate has the same value in B but different in C.
thannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnks