Saturday, October 15, 2016

yogi_Compute In Sheet2 Columns E and F Names And Corresponding Numbers Of Salesmen In Sheet1 Column E

Google Spreadsheet   Post  #2073
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-15-2016
question by: JoseLazoSDT:
https://docs.google.com/spreadsheets/d/1LvlgvE1K2fJAqy7sRKe7PXmwBS6uOQWEORL41ZxU860/edit#gid=0
How to count number of names in a column then display the results
Can't figure out how to count the number of times a salesperson name comes up in column E on sheet1 then display how many times each individual name is counted on sheet2.

Something like:

EDUARDO E1
GABRIEL G1


https://docs.google.com/spreadsheets/d/1LvlgvE1K2fJAqy7sRKe7PXmwBS6uOQWEORL41ZxU860/edit?usp=sharing

-----------------------------------------------------------------------------------------------------