analysis

I'm trying to extract the first three characters in a cell and have found this which works for numbers and text apart from where the cell begins with a 0 or multiple 0's Sub CompareScheme() Dim SourceRange As Range Dim DestinationRange As Range Dim Z As Integer Set SourceRange =...

Hello, Not entirely sure if this is possible... I'd like to somehow get a count of how many locations each player has scored 5 or more points in, details below. Basically there is an Olap cube set up which I do not have access to change. As a simplified example the data that I have is set...

Dear Recipients, Please take a look at the below chart. <table border="0" cellpadding="0" cellspacing="0" height="264" width="280"><col style="mso-width-source:userset;mso-width-alt:3547;width:73pt" width="97"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78">...

Dear All, I have historical prices of a FTSE 100 index. There are two columns, Times and Price. The time is uneven and is in seconds For instance: Time Price 2011-04-01T07:12:35.412Z 5949.6 2011-04-01T07:12:35.412Z 5949.4 2011-04-01T07:12:35.412Z 5949.4...

Hi, I joined this forum hoping someone will be able to stop me tearing my hair out! I have just completed vistor surveys of nature reserves and am looking to do some simple analysis of the results using excel, this is fine until i reach a few of our questions. We were asking what improvements...

Hi, I am analysing a bunch of file data and due to the large volume of data the sorts and filters take ages to run. Column B contains the size of the files in bytes. Columns D, E and F contains their last access, date created and last modified dates. Column H contains the file extension. I...

What I want to do with my data is a little beyond my knowledge base so I'm hoping someone can help me. I want to do an analysis on an existing database of data which will tell me the sequence of products ordered for the whole database. The database order section is set up with the following...

Hi, fellow Excel designers, I've been searching the net for the entire day now. I'm looking for an easily analysable timeline. For example, this is how my data looks like: It shows each entire day and the events that happened on that day in accordance to a conveyor belt where products are...

I am hoping to see if it is possible to create a spreadsheet to compare cell phone costs on a monthly basis. The info I would like to input is minutes used, text used, overage minutes, overage texts, and even data packages. In the end I would like to create a graph that shows a rage of plans...

Hello! I'm sure this has a simple solution, but I have a ways to go when it comes to VBA... <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I am trying to pull information from multiple web pages for historical analysis. The fist site is...

I have a group of 100 agents who have to evaluate a telephone call and then select the type of call from a drop down list of 200 entries. Because all agents have the same chance of getting the same mix of calls, their selection mix should be relatively similar. I want to be able to show using...

Hi, Could someone please explain to me how to use the correaltion analysis on Excel 2007? Im Struggling. I merely want a graph showing the correlation between 2 sets of data. Thanks in advance :)

I am in charge of reviewing multiple tests from around the country and evaluating each question, each testing site, etc. I need to find an easy way with excel if possible to input the "answer key" in collum A then each of the tests that I receive from the testing locations in collums B, C...