# Tagged Questions

**1**

vote

**1**answer

50 views

### Automatically sorting a range of cells after one cell within the range has been modified?

I have a number of named vertical ranges on a spreadsheet, containing lists of names. New names are usually manually added at the very end of each list. Obviously, this means that unless manually ...

**-4**

votes

**2**answers

122 views

### Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
...

**0**

votes

**2**answers

279 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

**1**answer

44 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

**0**answers

83 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

**0**answers

50 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

**1**answer

134 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

**0**answers

160 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

**1**answer

2k 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

**1**answer

68 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

**2**answers

53 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

**1**answer

150 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

**1**answer

160 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

**3**answers

2k 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

**2**answers

80 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

**1**answer

32 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

**2**answers

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

**3**answers

7k 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?

**1**

vote

**6**answers

14k 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

**3**answers

11k 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

**0**answers

250 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

**1**answer

312 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

**1**answer

5k 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

**3**answers

126 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

**3**answers

187 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

**1**answer

410 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 ...