Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I want to delete rows from below data
For example Column A has dates and B has names so for each date in column A I want to delete entire row if column B has more than four cells
in below data For first date want to delete row 6 and 7 for becuase they are rows 5 and 6 after first date
For second date I want to delete row 12 becuase it's 5th number after second date
Data
Expected Result
For example Column A has dates and B has names so for each date in column A I want to delete entire row if column B has more than four cells
in below data For first date want to delete row 6 and 7 for becuase they are rows 5 and 6 after first date
For second date I want to delete row 12 becuase it's 5th number after second date
Data
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Date | Name | Number | |||
2 | 1/1/2022 | A | 1 | |||
3 | B | |||||
4 | C | |||||
5 | D | |||||
6 | E | |||||
7 | F | |||||
8 | 1/2/2022 | A | 2 | |||
9 | B | |||||
10 | C | |||||
11 | D | |||||
12 | E | |||||
13 | 1/3/2022 | A | 3 | |||
14 | B | |||||
15 | C | |||||
16 | D | |||||
17 | 1/4/2022 | A | 4 | |||
18 | B | |||||
19 | C | |||||
20 | D | |||||
21 | E | |||||
22 | F | |||||
23 | 1/5/2022 | A | 5 | |||
24 | ||||||
Sheet1 |
Expected Result
Book1 | |||||
---|---|---|---|---|---|
F | G | H | |||
1 | Date | Name | Number | ||
2 | 1/1/2022 | A | 1 | ||
3 | B | ||||
4 | C | ||||
5 | D | ||||
6 | 1/2/2022 | A | 2 | ||
7 | B | ||||
8 | C | ||||
9 | D | ||||
10 | 1/3/2022 | A | 3 | ||
11 | B | ||||
12 | C | ||||
13 | D | ||||
14 | 1/4/2022 | A | 4 | ||
15 | B | ||||
16 | C | ||||
17 | D | ||||
18 | 1/5/2022 | A | 5 | ||
19 | |||||
Sheet1 |