davidlatics
New Member
- Joined
- Jan 18, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi, I wonder if anyone can help me please – I’ve tried searching previous posts but I’m unable to find a solution to my query.
Spreadsheet 1 consists of hundreds of rows of data - a sample is below. Spreadsheet 2 includes exactly the same rows as Spreadsheet 1, plus a handful of new entries. However, these new rows could be located anywhere within the sheet.
I would like to find a way of deleting all the duplicate rows on Spreadsheet 2 (when compared with Spreadsheet 1) to leave only the new rows. I have to repeat this process each day (i.e. comparing that day’s data to the previous day) so any help would be massively appreciated. I am using Office 365.
Spreadsheet 1 consists of hundreds of rows of data - a sample is below. Spreadsheet 2 includes exactly the same rows as Spreadsheet 1, plus a handful of new entries. However, these new rows could be located anywhere within the sheet.
I would like to find a way of deleting all the duplicate rows on Spreadsheet 2 (when compared with Spreadsheet 1) to leave only the new rows. I have to repeat this process each day (i.e. comparing that day’s data to the previous day) so any help would be massively appreciated. I am using Office 365.
NA 0115.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Op. Al | Origin | DepAptName | DepCtryName | ArrAptName | ArrCityName | ArrCtryName | Destination | |||
2 | 2D | BOS | Boston Edward L Logan Intl Apt | USA | Belo Horizonte Tancredo Neves Int Apt | Belo Horizonte | Brazil | CNF | |||
3 | 2D | YYZ | Toronto Lester B Pearson Intl | Canada | Georgetown (GY) 00 | Georgetown (GY) 00 | Guyana | GEO | |||
4 | 4B | CNM | Carlsbad | USA | El Paso International Apt | El Paso | USA | ELP | |||
5 | 4B | ELP | El Paso International Apt | USA | Carlsbad | Carlsbad | USA | CNM | |||
6 | AA | AUS | Austin-Bergstrom International Apt | USA | Boston Edward L Logan Intl Apt | Boston | USA | BOS | |||
7 | AA | AUS | Austin-Bergstrom International Apt | USA | Orlando International Apt | Orlando | USA | MCO | |||
8 | AA | AUS | Austin-Bergstrom International Apt | USA | San Jose Norman Y. Mineta Intl | San Jose (US) | USA | SJC | |||
9 | AA | BOS | Boston Edward L Logan Intl Apt | USA | Austin-Bergstrom International Apt | Austin (US) TX | USA | AUS | |||
10 | AA | BOS | Boston Edward L Logan Intl Apt | USA | Fort Lauderdale/Hollywood Intl Apt | Fort Lauderdale | USA | FLL | |||
11 | AA | BOS | Boston Edward L Logan Intl Apt | USA | Hilton Head Island | Hilton Head Island | USA | HHH | |||
12 | AC | YOW | Ottawa McDonald - Cartier Intl Apt | Canada | Cayo Coco | Cayo Coco | Cuba | CCC | |||
13 | AC | YUL | Montreal Pierre Elliott Trudeau Int Apt | Canada | Toulouse | Toulouse | France | TLS | |||
14 | AC | YYZ | Toronto Lester B Pearson Intl | Canada | Brussels Airport | Brussels | Belgium | BRU | |||
15 | AS | AUS | Austin-Bergstrom International Apt | USA | Los Angeles International Apt | Los Angeles (US) | USA | LAX | |||
16 | AS | BOI | Boise | USA | Everett | Everett | USA | PAE | |||
17 | AZ | SFO | San Francisco | USA | Rome Fiumicino Apt | Rome (IT) | Italy | FCO | |||
18 | B6 | ATL | Atlanta Hartsfield-jackson Intl Apt | Atlanta | USA | Newark Liberty International Apt | New York | USA | EWR | ||
Sheet1 |