google sheet database count function
Budget: $10 – $30 USD
I'm looking to have a count function set up in a google sheet
1. I have a database of orders in csv file. the data from the csv file will be pasted into the google sheet
2. the sheet will have a column for an order number. each order is attributed to a unique ID, listed in an adjacent column
3. I have a database of ~90 IDs that I can provide for lookup
4. I want a count of the number of orders by ID
5. I want to be able to sort the number of orders by ID
6. I want to be able to paste in a new database of orders to update the number of orders by ID
7. Then I want to associate the ID to a name
8. so the output would be X count of Y ID and Z name
Here is an example google sheet where the function can be applied: https://docs.google.com/spreadsheets/d/1_02zOIAh9jhrVPRRx2OywLL_ZGOHuK_BzodQZfTdhow/edit?usp=sharing
1. I have a database of orders in csv file. the data from the csv file will be pasted into the google sheet
2. the sheet will have a column for an order number. each order is attributed to a unique ID, listed in an adjacent column
3. I have a database of ~90 IDs that I can provide for lookup
4. I want a count of the number of orders by ID
5. I want to be able to sort the number of orders by ID
6. I want to be able to paste in a new database of orders to update the number of orders by ID
7. Then I want to associate the ID to a name
8. so the output would be X count of Y ID and Z name
Here is an example google sheet where the function can be applied: https://docs.google.com/spreadsheets/d/1_02zOIAh9jhrVPRRx2OywLL_ZGOHuK_BzodQZfTdhow/edit?usp=sharing