Description of the problem
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Description of the problem

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    INDIA
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi yogi and daleyman
    thanx for replying fast i will give try explaining my problem once again.
    Objective of research: to study the frequency of words occurring in different texts and the space that they occupy.
    I have a excel file with 101 sheets of data.
    sheet 1 is the master where all calculations are done and the remaining 100 sheets have text in them. the process in which text has been imported into excel is by opening the text files and delimiting them according to tabs, space, colon, |, comma thus each of the 100 text files have been imported into excel and put in 100 sheets. Now as the text is delimited and imported into excel each cell of the sheet in which text is there contains a single word only{i have seen to that}. The range where the text is in 100 sheets varies from sheet to sheet, in some sheets it starts from a!1:500 and in other sheets it goes upto a!1:1500 which is the maximum. thus the maximum range of the text in any sheet i have kept it as A!1:1500. Now I have chosen some 250 most commonly occuring words in english langauage and used countif functions to find out the frequency of each of those words in all the 100 sheets of text. now the problem is i want to find out staying in the master sheet the total no. of words in each sheet of text and the total bytes that they occupy{excluding characters like ,./*" and ascii}.
    whew i hope it is satisfactory please send me your email so that i could send u the file if needed.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    So you need alpha, numeric, and spaces?
    Tom

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com