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

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