Average Values if Equal to a Value in Another Column

[rossbaker]

I have a table full of phone numbers and call durations.

In A2:A6160, I have 162 different phone numbers and in U2:U6160, I have the call durations for calls made to those numbers.

In a separate spreadsheet, I have each number listed in Column A and in Column D, I want to display the average call duration for each of the numbers.

Thanks in advance.

[Ron Coderre]

Which version of Excel will you use?

[rossbaker]

Excel 2007

[Ron Coderre]

Try something like this:

Please Login or Register  to view this content.

Is that something you can work with?