Forum Discussion
please help me find Duplicates
http://powerpivotforum.com.au/viewtopic.php?f=6&t=1055 Kindly hlp me identify the duplicates.
ok, if we place Airline [ or any of the fields which is shown on the data table]
we get a table with measure tells us each row by row which is 1st entry and 2nd entry and 3rd entry.
so here i dont necessarily have to pull all the fields [
| Airline | ICAO Flight No | From | To | Aircraft Type | Date |
result looks like this.
| Airline | Date | Measure |
| Air Canada | 43149 | 1 |
| Air Canada | 43149 | 2 |
| Air Canada | 43149 | 3 |
| British Airways | 43151 | 1 |
| British Airways | 43151 | 2 |
| Emirates | 43156 | 1 |
| Emirates | 43156 | 2 |
or
| Airline | ICAO Flight No | Date | Measure |
| Air Canada | ACA17 | 18-Feb-18 | 1 |
| Air Canada | ACA17 | 18-Feb-18 | 2 |
| Air Canada | ACA17 | 18-Feb-18 | 3 |
| British Airways | BAW19 | 20-Feb-18 | 1 |
| British Airways | BAW19 | 20-Feb-18 | 2 |
| Emirates | UAE114 | 25-Feb-18 | 1 |
| Emirates | UAE114 | 25-Feb-18 | 2 |