Count the text which are same

Posted by: mohanmuthusamy on 8 September 2017, 1:10 pm EST

  • Posted 8 September 2017, 1:10 pm EST

    Dear All,
                   I need to count the number of same word in the spreedsheet inwindows application
    For Example;
    There are 10 rows and 1 column in spread sheet
    column                 Text
     1                          FarPoint
     2                          spreed
     3                          FarPoint
     4                          FarPoint
     5                          FarPoint
     6                          FarPoint
     7                         FarPoint
    8                          FarPoint
     9                         spreed
    10                          FarPoint

    if i want to count the "FarPoint"  word  . The output will be 8
    Please help me  how we find this  output
  • Replied 8 September 2017, 1:10 pm EST

    There is not a method that will return an array of found items.  See these posts...

    http://www.clubfarpoint.com/Forums/forums/thread/46071.aspx

    http://www.clubfarpoint.com/Forums/forums/post/22284.aspx
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels