Most valuable professional
  • Hot Topics

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 7, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel