[chaim]

Hi all!

I recently found that I can download my outgoing call log in excel sheet.
I want to make a tool which will analyze my log and tell me who are the most talked to numbers, and for how much time i talked with them.

made a dummy spreadsheet : peledummy.xls

I'm calling from number 53 to numbers 52, 54, 55. sometime i send them sms. I only want to analyze the phone calls not the sms.

Would be realy interested to hear your thoughts, didn't use excel for a time.

Thank you in advance
Chaim

[Aj_old]

You should use a Pivot Table. Take a look at the attached file and see if this is what you want.

[chaim]

wow, great! thanks alot!