default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hey everyone!
I have a large table which has many columns (from A to CU).
I have been populating this table with data from several different places (same format).
There are occasionally some lines/rows in the table that are duplicates.
Is there a way to identify these duplicated rows and to have them copied into a blank spreadsheet so that I may review them?
Hope that makes sense.
It's something like this:
In this case, rows 2 and 5 are identical....is there a way to extract these rows (remove them from this spreadsheet) and to paste them into a blank spreadsheet?
I have a large table which has many columns (from A to CU).
I have been populating this table with data from several different places (same format).
There are occasionally some lines/rows in the table that are duplicates.
Is there a way to identify these duplicated rows and to have them copied into a blank spreadsheet so that I may review them?
Hope that makes sense.
It's something like this:
In this case, rows 2 and 5 are identical....is there a way to extract these rows (remove them from this spreadsheet) and to paste them into a blank spreadsheet?
A | B | C | D | . . . . . . . . . . . . | CU | |
1 | Header1 | Header2 | Header3 | Header4 | . . . . . . . . . . . . | FinalHeader |
2 | Cheese | Blue | 3.56 | Up | . . . . . . . . . . . . | Yes |
3 | Grain | Green | 3.8 | Up | . . . . . . . . . . . . | Yes |
4 | Carrot | Purple | 5.95 | Left | . . . . . . . . . . . . | No |
5 | Cheese | Blue | 3.56 | Up | . . . . . . . . . . . . | Yes |
6 | Meat | Red | 1.22 | Left | . . . . . . . . . . . . | Yes |