Saturday, February 28, 2015

yogi_Compute The Nth Number Of Its Respective Occurrence of An Entity In An Array Of Entities

             Google Spreadsheet   Post  #1901
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-28-2015
question by ksivanantha:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/APg4_Iyl7O4
How to find the count (nth Number) of a repeating word
Dear Forum Members,

Please help me to find the count (nth Number) of a repeating word based on the occurrence (First entry 1, 2nds similar word, 2,3,..)

Example : Supplier type is repeating below & first stationery supplier to get the rank 1 and second stationery supplier Q to get 2.

Name of Supplier    Type of Supplier   Supplier Rank
A                              Stationery                1
B                              Grocery                   1
C                              Grocery                    2
X                              House Hold               1
P                              Grocery                    3 
Q                              Stationery                 2
-------------------------------------------------------------------------------------------------------------------------