table analysis

I am trying to shortlist a table by matching information from a list, and would appreciate your help. The list and the table are variable in size and content, the location in the table where the list members can be found also varies. Below is a simplified example of what I am looking at and what...

Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...

Hi there, I ran into a strange problem today. I received an excel file today and the underlying data is in table format. When i select the table and pivot it, there are 5 additional fields in the pivot and there are absolutely no hidden columns. For example, the table looks like Fruit Price...

I need to create a table to records some information in a excel sheet. So I tried to draft a table like this . <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Code Name Officer Advance Advance Date Receive Date Balance Due 1st Installment...

Hello, Below is a small portion of an existing large table already in use at my company and is updated on a weekly basis to track performance across multiple platforms and shows that we buy ads on: <tbody> A B C D E F G H I J K L M 1 Show1 Show1 Show1 Show1 Show2 Show2 Show2 Show2 Show3...

Hello, I really hope someone can help me or get me going in the right direction. I have a large project that I am working on but I do not imagine that it is all that difficult, I've just hit a brick wall in my thinking. The project is this: I have a spreadsheet of data provided to me containing...

Hi I have one spredsheet where the date, name, team, results are recorded. <TBODY> Date</SPAN> Exec Name</SPAN> Team</SPAN> Internal Process</SPAN> Client Impact?</SPAN> Final Status</SPAN> 27/01/2013</SPAN> Miguel Luis</SPAN> Tools team</SPAN> Fail Yes Fail 28/01/2013</SPAN>...

I have imported data from an online survey and am using a table to sort and analyze it. When I go to run a formula (Mode, Standard Deviation, etc.) it incorporates all the data that I've sorted out. How can I prevent that? -Justin