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     www.energyefficientbuild.com

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; https://docs.google.com/spreadsheet/ccc?key=0AhioeCK_-aU4dHpkOEVqZ3VpbWhoWFdoX01BcFJ5R2c#gid=0 
-------------------------------------------------------------
 following is a solution to the problem