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
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
No comments:
Post a Comment