Saturday, March 31, 2018

yogi_Pull Data In Two Columns Of Existing Table From Data In Another Sheet Of The Same Workbook

Google Spreadsheet   Post  #2409

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Mar-31-2018
How to count the number of repeated values for two data points

by Ryan G White

 9:16 AM
ADD A REPLY
I have a list of clients that were acquired by specific team members. I want to be able to track the total number of clients each person has gotten to the deposit stage and the withdrawn stage for training purposes. Here is the link for a test spreadsheet:
https://docs.google.com/spreadsheets/d/1cDrdrAZHf3fIsvwc7d_32Y00t_Z1u8M30SU9Z2jX8VE/edit?usp=sharing
I have also attached two images of the spreadsheet - with the one with three columns of values being the original data and the one with two empty columns being where I want the values to be. The intention would be to have next to Bob's name: in the Deposit column the number 1 and in the withdrawn column the number 2.