excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hello!
how to rule out (delete) 2 set's of 2 identical numbers in any order?
and also set's of 4
with a macro please
example for deletion:
1 1 2 2
5 8 8 5
1 2 1 2
7 7 7 7
how to rule out (delete) 2 set's of 2 identical numbers in any order?
and also set's of 4
with a macro please
example for deletion:
1 1 2 2
5 8 8 5
1 2 1 2
7 7 7 7
sheet1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 1 | 1 | 2 | 2 | delete | ||
2 | 1 | 1 | 2 | 3 | |||
3 | 1 | 1 | 2 | 4 | |||
4 | 1 | 1 | 2 | 5 | |||
5 | 1 | 1 | 2 | 6 | |||
6 | 1 | 1 | 2 | 7 | |||
7 | 1 | 1 | 2 | 8 | |||
8 | 1 | 1 | 3 | 2 | |||
9 | 1 | 1 | 3 | 3 | delete | ||
10 | 1 | 1 | 3 | 4 | |||
11 | 1 | 1 | 2 | 2 | delete | ||
12 | 5 | 8 | 8 | 5 | delete | ||
13 | 1 | 2 | 1 | 2 | delete | ||
14 | 7 | 7 | 7 | 7 | delete | ||
22 |