Saturday, April 7, 2012

yogi_Count The Instance Number Of An Entity In A Column And Add To The Name Of Entity

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #495    Apr 7, 2012

user Dnrg26 said: 
Hi eve Hoping someone can help me out on this. Is it possible to get ArrayFormula for this? Formula Start From D5 as =IF(D5="","",D5&COUNTIF($D$5:D5,D5)) and D6 and Below will be accordingly as =IF(D6="","",D6&COUNTIF($D$5:D6,D6)) =IF(D7="","",D7&COUNTIF($D$5:D7,D7)) . . . Etc. Thanks 
See the Result; 
 following is a solution to the problem