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.