Advertisement

07.15.2008 at 02:32AM PDT, ID: 23565459
[x]
Attachment Details

Text count in excel worksheet

Asked by philsivyer in Ruby Scripting Language

Hello
Not sure if Ruby is suited to the following or not?
In a given worksheet certain text can be repeated in any given cell - Ideally I would like an Input box where I can type in text to search - 2nd input box to select range required - and the output to another worksheet.  There will be more than one type of text search for and not sure if I can enter more than one piece of text to search for in the input box? So, let say the following peices of text require a count in a given range and the output would be as follows:
Column A                              Column B
Time to Answer                     11
Resolution Time                      7
Helpdesk                                45

Your help much appreciated
Phil
Start Free Trial
[+][-]07.15.2008 at 06:43AM PDT, ID: 22006881

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Ruby Scripting Language
Sign Up Now!
Solution Provided By: fridom
Participating Experts: 1
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628