How can I accomplish this? Column B will always have duplicate values and I want to remove the duplicates but with a catch.
I want the end result to look like this. Essentially trying to delete duplicate values on Column B ONLY IF they are in successive rows. i,e if I see James on Rows 2,3,4, 21,22,23 I want to delete James from Rows 3,4 and 22,23 without shifting the cells to look like this
Any thoughts?
Book1 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Order Type | Name | Number | ||
2 | First | John | 45654 | ||
3 | Second | John | 45665 | ||
4 | Third | John | 45878 | ||
5 | First | Jack | 56887 | ||
6 | Second | Jack | 54513 | ||
7 | Third | Jack | 15687 | ||
8 | First | James | 78954 | ||
9 | Second | James | 65895 | ||
10 | Third | James | 23564 | ||
11 | First | Jane | 23545 | ||
12 | Second | Jane | 12562 | ||
13 | Third | Jane | 12564 | ||
14 | First | Jose | 12357 | ||
15 | Second | Jose | 45879 | ||
16 | Third | Jose | 15877 | ||
17 | First | Helen | 15448 | ||
18 | Second | Helen | 65897 | ||
19 | Third | Helen | 78884 | ||
20 | fourth | Helen | 45658 | ||
21 | First | James | 87945 | ||
22 | Second | James | 46593 | ||
23 | Third | James | 32148 | ||
Sheet4 |
I want the end result to look like this. Essentially trying to delete duplicate values on Column B ONLY IF they are in successive rows. i,e if I see James on Rows 2,3,4, 21,22,23 I want to delete James from Rows 3,4 and 22,23 without shifting the cells to look like this
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Order Type | Name | Number | |||
2 | First | John | 45654 | |||
3 | Second | 45665 | ||||
4 | Third | 45878 | ||||
5 | First | Jack | 56887 | |||
6 | Second | 54513 | ||||
7 | Third | 15687 | ||||
8 | First | James | 78954 | |||
9 | Second | 65895 | ||||
10 | Third | 23564 | ||||
11 | First | Jane | 23545 | |||
12 | Second | 12562 | ||||
13 | Third | 12564 | ||||
14 | First | Jose | 12357 | |||
15 | Second | 45879 | ||||
16 | Third | 15877 | ||||
17 | First | Helen | 15448 | |||
18 | Second | 65897 | ||||
19 | Third | 78884 | ||||
20 | fourth | 45658 | ||||
21 | First | James | 87945 | |||
22 | Second | 46593 | ||||
23 | Third | 32148 | ||||
24 | ||||||
Sheet4 |
Any thoughts?