Average cells based on column data

[fordmudslinger]

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!

 

[lrobbo314]

I would turn your data into a pivot table.

Select your data, hit Ctrl+N+Z, or click insert Pivot Table.

Then add Customer name to Rows. Add Time Spent to Values. Then change the Field Value Settings for the Time spent to be Average instead of the default of Sum.

 

[fordmudslinger]

I would turn your data into a pivot table.

Select your data, hit Ctrl+N+Z, or click insert Pivot Table.

Then add Customer name to Rows. Add Time Spent to Values. Then change the Field Value Settings for the Time spent to be Average instead of the default of Sum.

That works perfectly...thanks so much; great help!

 

[lrobbo314]

No problem! Glad it worked out.