fordmudslinger
Board Regular
- Joined
- Apr 4, 2015
- Messages
- 64
Hi, I have a database of customers and how long we are at their property each time we visit it thru the year. In column A is the customers name and column g is the amount of time we are there. Now in column a the customers name is listed each time we visited their property, each customer is listed different amounts of time. One customer may have been serviced 8 times during the year and some 20 times. Regardless, their name is in column a however many times we serviced them followed by other data in the same row regarding their property.
Is there a way to average column g for each customer to find average of time? It would have to look at column a and see the customers name and pull only the time from column g for that customer, return the result to column l and move on to the next customer.
Thanks!
Is there a way to average column g for each customer to find average of time? It would have to look at column a and see the customers name and pull only the time from column g for that customer, return the result to column l and move on to the next customer.
Thanks!