Operators Licence Spreadsheet Project
Budget: $10 – $30 USD
Operators Licence Spreadsheet Project
1) Regarding the spreadsheet named “Operators Centres Tables”:
a. Remove the columns B to E.
b. Merge all rows with the same licence_number and total the values in the vehicles column for all of the records with the same licence_number
2) Match all the rows in the spreadsheet “2 – Company Table” to the spreadsheet “Operators Centres Tables” using the licence_number
1) Regarding the spreadsheet named “Operators Centres Tables”:
a. Remove the columns B to E.
b. Merge all rows with the same licence_number and total the values in the vehicles column for all of the records with the same licence_number
2) Match all the rows in the spreadsheet “2 – Company Table” to the spreadsheet “Operators Centres Tables” using the licence_number
Related categories:
Excel