table analysis

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