ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Random ListKeep / Delete
2
Item 1042Keep
How to use this sheet:
3
Item 1043Keep
1. Column B already follows the pattern: keep 2 rows, delete 3 rows, repeating.
4
Item 1044Delete
2. Select A4:B24, go to Data > Sort, and sort by column B (Keep / Delete) A to Z.
5
Item 1045Delete
3. All the 'Delete' rows will group together below the 'Keep' rows.
6
Item 1046Delete
4. Select those 'Delete' rows and delete them.
7
Item 1047Keep
5. Optional: once you're done, delete column B or convert it to values first (Copy > Paste Special > Values) so it doesn't keep recalculating as you delete rows.
8
Item 1048Keep
9
Item 1049Delete
10
Item 1050Delete
11
Item 1051Delete
12
Item 1052Keep
13
Item 1053Keep
14
Item 1054Delete
15
Item 1055Delete
16
Item 1056Delete
17
Item 1057Keep
18
Item 1058Keep
19
Item 1059Delete
20
Item 1060Delete
21
Item 1061Delete
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100