Excel: Creating Formula for Pivot Tables


Hi everyone, I'm new here and am having some problems. I want to create a pivot table for work that tracks calls, contacts, email, voicemail, and meetings and track ratios for employees. The problem is that all of that information is contained in 1 column, and I can't figure out a formula to track each of those things for all the employees. I thought of creating a giant "if/then" statement, but it just became so complicated. Can anyone help me / point me in the proper direction.


This question generated 20 answers. To proceed to the answers, click here.

This thread is current as of February 07, 2014.


For more resources for Microsoft Excel