0
votes
2answers
28 views

Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed. However I can't delete it in the excel Name Manager: Any suggestion why I cannot delete it? ...
0
votes
1answer
24 views

How to prevent all-filtered-out row label values from appearing in a pivot table?

I have a pivot table in MS Excel. For the same of example, suppose the basic data has 3 columns: Name: A string. CountMe valued either 0 or 1. Year an integral number. Tokens the data we're ...
0
votes
0answers
56 views

Indirect lookup across spreadsheets

I have a spreadsheet that has information about all products for every week of the year. Currently I have a second spreadsheet that is setup to look at the first one for each field (currently has 52 ...
0
votes
0answers
40 views

Don't want to include blank rows in Excel table

I have a table in excel which contains the following columns: Brands: Cell B Open Closed: Cell C Case Number: Cell E Case Summary: Cell G At the moment these are the following formulas I am using ...
-1
votes
1answer
100 views

How to get data from separate worksheets displayed in a single separate worksheet

I am working on a spreadsheet in Microsoft excel 2010. In the spreadsheet I have 3 worksheets. These are known as: 1st 2nd Cases Now in the 1st and 2nd Worksheets, there is a table at the bottom ...
0
votes
0answers
122 views

How can I create a matrix chart with Excel 2010?

I want to create a chart where, if the value of a cell matches the criteria of both its row and column, I can mark it with a cross. I could just type an 'x' into the cell, but I would like to find ...
2
votes
1answer
1k views

Split Text into Columns Function in Excel

I have an excel spreadsheet with rows of data as shown below. There is a code with the product name and then a number. QA32 Product One (Large) 23 AZ63 Product Two 96 PR65 Product Three 149 How do ...
0
votes
1answer
64 views

Excel: How to efficiently check whether a selected cell is referenced in any other cell

I want to check whether a selected cell ( say A1) is referenced in any other cell in the sheet I’m working in? Is there a similar tool that shows you arrows from the selected formula to referenced ...
0
votes
2answers
50 views

Using conditions to write to new row on new sheet to return value

I would like to be able to use a data-entry page or form to keep track of monthly fulfillment of orders. We have some number of SKUs, lets say 10, and various number of orders against each SKU. ...
0
votes
1answer
100 views

Retaining cell formatting in a formula

I'm looking for a way to pass along text formatting when combining cells in a formula. The image attached shows a similar instance of the result I would like. If I combine A1 and A2 and A3 with the ...
0
votes
1answer
145 views

Vlookup not working as expected for soccer data

i have a vlookup function that is supposed to give me some data from another worksheet. the worksheet contains soccer data, specifically about the european cups of the past 3 years (9-10, 10-11,11-12, ...
0
votes
3answers
1k views

How to change the hh:mm:ss format in spreadsheets

Currently, I have a data set which is "mm:ss" and needs to stay / be calculated that way. The problem is, Microsoft Excel, Google Spreadsheets and OpenCalc all interpret "mm:ss" as "hh:mm" and to add ...
2
votes
2answers
78 views

What is { } used for in Microsoft Excel 2010?

I came across this function in one of my worksheets and wanted to know what the curly braces are used for. Here is an example. {=array(sheet1!a1,sheet2!a3,sheet2!a5,sheet2!a6)}
0
votes
1answer
29 views

Averaging unique columns in Excel

I'm probably missing something very obvious, but I have the following data: ACCT 4 ACCT 2 CS 20 CS 10 ENG 20 ENG 10 ENG 30 What I want is to get the average of each department. So it should ...
0
votes
2answers
1k views

Complex rota hours calculation in excel

OK so there are a number of different shifts in operation here and I want a total hours formula. problem is the rota is written using a number of different notations for different shifts some are ...
2
votes
3answers
6k views

How to refer to the last cell in a row in Excel?

Which function can I use to get the value of the last not empy cell in a row in Excel 2010?
0
votes
6answers
11k views

Can't insert cells in Excel 2010 - “operation not allowed” error message

I was working on a spreadsheet in Excel 2010, and all of a sudden when I attempted to insert a new row of cells, I saw that the insert and delete options were grayed out. I attempted to copy a ...
3
votes
3answers
9k views

How can I enable the creation and editing of hyperlinks in shared Excel worksheets?

I have hyperlinks in some Excel 2010 (both .xlsx and .xls formats) worksheets. If I enable sharing of the workbook I can no longer edit or create hyperlinks - the options no longer exist on the menu ...
2
votes
0answers
210 views

Multilingual spreadsheet

I need to make a spreadsheet template that needs to be support both English and Spanish. I know Office 2010 has an option to translate content into desired language but its a manual process. Is there ...
0
votes
1answer
272 views

Creating a chart with two date columns

I have some data from Google Analytics relating to traffic to one of my websites. I would like to compare the traffic from now to the same time one year ago. However, to be difficult I do not simply ...
0
votes
1answer
4k views

Excel formula to find frequency of occurrence of unique words in a column

I have a spreadsheet with a column with repeating number of different kinds of words like A1 A2 A3 A1 AA A2 A7 A8 A1 Now I want to plot a graph showing the frequency of occurrences of a word. The ...
0
votes
3answers
121 views

Re-ordering data in a cell in spreadsheet

I have an Excel spreadsheet where data is time stamped, but the time stamp is as follows (in one cell): Fri Mar 11 If it was 11 Mar Fri, the data would be easier to sort. How do I change the ...
1
vote
3answers
184 views

Excel plot chart from data as given in the example

I have a huge spreadsheet with simple data as follows 13:04:28 A 13:04:37 A 13:06:56 B 13:07:03 B 13:07:10 C 13:07:18 C 13:07:23 C 13:07:28 C 13:07:33 C Basically ...
0
votes
1answer
401 views

Excel filter by range

I am setting up a workout schedule. I have multiple rows with workout times, who is instructing the class, and who the class is suitable for. The suitable is a range, based on the following (anyone ...