ashleynsloan
New Member
- Joined
- Dec 4, 2013
- Messages
- 4
Hi,
I am having a serious dilemma. I am completely confident in deleting and highlighting duplicates in a sheet, however, now, I need to extract rows of duplicates in column B (all multiples, leaving only unique single values in the original sheet) and create a new sheet.
I need to split the original sheet of over 80,000 rows of information into single orders and multiple orders, so that they may be later consolidated.
Excel Help Forum
This is a brief sample of the sheet. I need the duplicates to be from column B. I tried doing a countif earlier (as shown by the million 2's in column C= epic fail) to try and split it into different steps...
So if,
Column B
A
A
A
B
D
E
E
New sheet would read:
A
A
A
E
E
*Note: of course the entire row would need to be moved, not just the column *
Please help! This would take me days to do manually. I'm not the most Macro/Excellent proficient, so exact and easy to understand works best!
Thanks so much
I am having a serious dilemma. I am completely confident in deleting and highlighting duplicates in a sheet, however, now, I need to extract rows of duplicates in column B (all multiples, leaving only unique single values in the original sheet) and create a new sheet.
I need to split the original sheet of over 80,000 rows of information into single orders and multiple orders, so that they may be later consolidated.
Excel Help Forum
This is a brief sample of the sheet. I need the duplicates to be from column B. I tried doing a countif earlier (as shown by the million 2's in column C= epic fail) to try and split it into different steps...
So if,
Column B
A
A
A
B
D
E
E
New sheet would read:
A
A
A
E
E
*Note: of course the entire row would need to be moved, not just the column *
Please help! This would take me days to do manually. I'm not the most Macro/Excellent proficient, so exact and easy to understand works best!
Thanks so much