excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi
how can i delete all rows containing 3 out of 4 predefined numbers ?
for example, predefined numbers are:
1 2 3 4
and i want to delete any row containing any combo of 3 out of these 4 ?
like:
1235 or 4128 or 6341 and so on
(without repeats of one the numbers like 8332=keep)
1 2 3 7 delete
5 6 2 7 keep
5 2 1 3 delete
6 7 2 4 keep
1 3 5 2 delete
4 5 2 3 delete
2 2 1 5 keep
1 3 5 5 keep
8 3 3 2 keep
how can i delete all rows containing 3 out of 4 predefined numbers ?
for example, predefined numbers are:
1 2 3 4
and i want to delete any row containing any combo of 3 out of these 4 ?
like:
1235 or 4128 or 6341 and so on
(without repeats of one the numbers like 8332=keep)
1 2 3 7 delete
5 6 2 7 keep
5 2 1 3 delete
6 7 2 4 keep
1 3 5 2 delete
4 5 2 3 delete
2 2 1 5 keep
1 3 5 5 keep
8 3 3 2 keep
sheet1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | 1 | 2 | 3 | 7 | delete | ||
2 | 5 | 6 | 2 | 7 | keep | ||
3 | 5 | 2 | 1 | 3 | delete | ||
4 | 6 | 7 | 2 | 4 | keep | ||
5 | 1 | 3 | 5 | 2 | delete | ||
6 | 4 | 5 | 2 | 3 | delete | ||
7 | 2 | 2 | 1 | 5 | keep | ||
8 | 1 | 3 | 5 | 5 | keep | ||
9 | 8 | 3 | 3 | 2 | keep | ||
sheet1 |