The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

7 views

### Excell 2010 Formula Query

I'm a little stuck with a sheet I'm creating at work.
Basically the sheet tracks performance across 3 fields for our suppliers. Delivery, Product Quality and Supporting Documentation.
I would like ...

**0**

votes

**1**answer

15 views

### Excel Reporting Funtions

Bare with me as this question has a couple of elements to it...
I have a training matrix with Company Organisational Chart in first few columns e.g. Unit Departments and Position Titles in first two ...

**3**

votes

**3**answers

16k views

### How can I hide 0% value in data labels in an Excel Bar Chart

I would like to hide data labels on a chart that have 0% as a value. I can get it working when the value is a number and not a percentage. I could delete the 0% but the data is going to change on a ...

**0**

votes

**1**answer

7k views

### Excel 2010: dynamic update of drop down list based upon datasource validation worksheet changes

I have one worksheet for setting up the data sources of multiple data validation lists.
in other words, I'm using this worksheet to provide drop down lists to multiple other worksheets.
I need to ...

**0**

votes

**2**answers

7k views

### Print preview doesn't work properly in Excel 2010

First I made some contents and drew a border from Home > Font > all Borders on an Excel 2010 file. So it became like below image (capture1). After that I wanted to print it so went to File > Print to ...

**1**

vote

**2**answers

3k views

### Excel 2010 Autofilter does not filter

I have a sheet with 69 columns and 6600 rows called Raw Data. I also have a sheet called Filtered Data. I have a drop down menu on the Filtered Data sheet in cell B4. The list in the drop down menu ...

**3**

votes

**1**answer

4k views

### Macros in Excel 2010 hangs

I have a spreadsheet with several macros. Generally, when previously using Excel 2007, a user clicks a button and everything works as expected (calculations, some email sending & file I/O). ...

**1**

vote

**2**answers

4k views

### Convert Day of the Year in Excel?

How can I convert Day of the Year to a mm/dd format in Excel?
Date of the Year: e.g. 1= Jan 1, 177 = June 27.
For example, how do I convert "177" to 6/27?

**0**

votes

**3**answers

3k views

### Excel saves a file in .csv but it keeps the columns and the rows as they were in the original sheet

I have a problem converting an Excel sheet in a *.csv file. I've searched all day for solutions, but nothing seems to work.
After I select the sheet and save it as "CSV(Comma delimited)", pressing OK ...

**0**

votes

**2**answers

48 views

### Excel: What can cause manual calculation / F9 to stop recalculating?

What can cause manual calculation/F9 to stop recalculating some cells properly in Excel 2010 ?
I've Googled this problem and ruled out all the explanations I can find:
Calculation settings are ...

**0**

votes

**1**answer

22 views

### Creation of an IF formula that will return a 1 or 0 for times between a range

I am trying to create a spreadsheet that will calculate total number of patients per hour. I have an arrival time and a discharge time. What I was thinking is to organize my spreadsheet with times on ...

**0**

votes

**1**answer

32 views

### Sum multiple items with multiple criteria

Given the following table, let's say I want to sum the New York "ACT" sales in Q2.
The answer would be 59. How do I do that with a formula?

**2**

votes

**1**answer

4k views

### Filter data in Excel based on column values matched to another column

I have this fairly easy to understand task but I can't figure out how this works in Excel.
I have a datasheet with a column (say ID, ranging from 1 to 10). On a second sheet I have a column (say ...

**4**

votes

**1**answer

3k views

### How can I create a separate window in an Excel spreadsheet?

I am working on an excel dashboard. I have several sections and would like to create one section with a "window" of data. The data will be pulled from another worksheet from the same workbook. The ...

**-2**

votes

**0**answers

9 views

### Creating a macro in excel that will copy and paste data from different worksheets [on hold]

I am trying to create a macro in excel that will copy all the rows in different worksheets that have the word "Rounding" and paste it into a new worksheet. Would anyone be able to help?
Coy

**3**

votes

**1**answer

37 views

### Sorting data without mixing rows

I have three sheets. First sheet renamed General:
Dave Henderson 21/05/2014
Elton Rus 22/06/2014
John Smith 20/05/2015
Second sheet renamed ...

**1**

vote

**4**answers

37k views

### Compare multiple columns for any two or more cells within the same row having the same content

I need a formula to compare multiple columns for any two or more cells within the same row having the same content. If that is true, then display "TEXT A" (can be anything such as "TRUE"). If all of ...

**0**

votes

**0**answers

14 views

### Prevent Categories in Pivot Table From Grouping Themselves - Excel

I grouped several categories together in a pivot table. After I did that, the remaining categories are automatically grouped to itself. How can I prevent
that?

**6**

votes

**5**answers

10k views

### Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...

**2**

votes

**2**answers

42 views

### Excel 2010 Range.FormulaArray using Range.Replace

I'm trying to automate some daily work where i use an INDEX()+MATCH() array formula to grab some data from different workbooks into one 'master' workbook. Manually this works as intended, but now I ...

**0**

votes

**1**answer

26 views

### Specific cell linked to Word causes Excel hangs

I have named over 200 specific cells in excel and have pasted them as link in a Word document for easy updating the Word file each time the Excel file is updated.
However, both Word and Excel often ...

**-3**

votes

**0**answers

9 views

### Excel 2010 Macros - Automation Error [duplicate]

When I upgraded to windows 10, a few macros I use in excel 2010 seem to have broken. They crash immediately when I run them and I receive an "automation error". They do not reference any outside ...

**2**

votes

**1**answer

3k views

### Excel 2010 macro to separate a large data file into workbooks

I found some code which works perfectly to separate a file based on a column (line 31) into separate tabs within a worksheet.
I just need it to separate the files based on a column into a separate ...

**0**

votes

**2**answers

21k views

### Plot multiple sets of x,y data on a single chart

Have several series of data I want to plot on the same chart:
Series A
X Y
4015188 7361762
4020374 9581526
4022289 10649655
4023878 11223132
4025512 12035416
4028600 13408580
4030353 ...

**-1**

votes

**1**answer

11 views

### Excel Data Import By row

I am using Excel to manage lab sample flow.
If at some point in the workflow, the sample does not pass onto the next step in the protocol, it will be eliminated from the next sheet I create.
I ...

**1**

vote

**1**answer

28 views

### SUMIF based on multiple criteria

I want to get the sum of a range, but I want to change how the sum us calculated based on critera.
Say I have a table as follows
Name | Value
DP | 2
DP + BC | 4
DP | 4
DP + BC | 6
So ...

**1**

vote

**3**answers

4k views

### Display multiple cells if data on another workbook contains “X”value

I export a complex report daily and I transfer that information manually into another excel sheet. My question is: In workbook 1, can I get a group of cells in a row to display the text in workbook 2 ...

**1**

vote

**3**answers

3k views

### Fast way to export data out into different excel files based on Column

There's some data like this (with over 500,000 entries)
Name | State
---- -----
Billy Utah
Sue California
Joe Utah
Sally California
John Michigan
...

**1**

vote

**3**answers

72 views

### Excel - How to return the first number only string that is between 7-10 characters long in a large body of text? (preferably Formulas only)

I'm trying to extract some numbers from a few cells that each have a large body of text.
The number strings are accompanied by certain words that precede the number string I'm trying to extract.
...

**0**

votes

**0**answers

20 views

### How to use colored cells along with multiple criteria data in formulae

I have an issue where I need to use SumIf/SumIfs formula to accomplish the following:
- Find cells within the spreadsheet filled with different colors which indicates a specific product and test for ...

**0**

votes

**0**answers

38 views

### Excel 2010 - Combine specific sheet in >200 separate files into single worksheet?

I have tried solutions in other posts like this and so far nothing has worked :/
I have >200 separate excel files, and essentially I would like a specific sheet from each of these files combined into ...

**0**

votes

**0**answers

12 views

### Countifs/Sumifs with multiple reference columns

I'm trying to make a COUNTIFS/SUMIFS formula which will work out the same values whether a value lies in any one of a number of columns.
My starting point for a single column lookup is as follows:
...

**0**

votes

**1**answer

29 views

### Formula to reference a cell value that contains text and retain the cell refences formatting

I have a bunch of cells containing text. The text in those cells have multiple font sizes and styles. I need to replicated those cells in a different order further down the worksheet and if I make ...

**3**

votes

**1**answer

11k views

### How do I change language (not dictionary!) in Excel 2011 for Mac?

How do I change language in Excel 2011 for Mac?
I'm not asking about the dictionary, I'm asking about the language of the program itself, i.e. the one of the menus.
(in case this matters, I'm using ...

**1**

vote

**1**answer

3k views

### VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell.
For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...

**0**

votes

**0**answers

18 views

### Excel Table Format

I have a spreadsheet with multiple tables (they're not actually formatted as tables but as charts) that are listed one after another. I would like each table to alternate in color. I would also like ...

**1**

vote

**2**answers

10k views

### Excel crashes everytime when saving a specific file

The instant I try saving a particular excel document excel will crash.
How do I solve this problem, I've tried saving as different excel formats but I got the same result, except for when I saved it ...

**0**

votes

**2**answers

42 views

### Complex Excel formula HELP please

I'm trying to calculate annual mileage for each vehicle on an excel spreadsheet that has a list of different vehicles and their odometer entries.
Can you please recommend a formula that calculates ...

**0**

votes

**1**answer

23 views

### Sum of specific cells, up to a given amount

I am attempting to create an overflow spreadsheet using formulas. The "Starting Petty Cash" (on the right) is the carryover from the previous term, and is manually entered. The "Count", just above ...

**-2**

votes

**1**answer

50 views

### Multiple conditions in a single Excel formula

I want to be able to have the cells in Column F set so that if I have the adjacent cell in column E say something then it will display a certain number.
Cell e and F are currently set has lists if ...

**0**

votes

**1**answer

3k views

### Mysterious “Reference not valid”

I have a big sheet with 30+ pivot tables made from the same 3 named tables.
Every time i run refresh all I get the Reference Not Valid-error.
I have no idea which pivot table is causing the error ...

**0**

votes

**1**answer

3k views

### Grand Average in place of Grand Total in Pivot Table

In a pivot table I want to change the Grand Total field to Grand Average. For example.
Row Labels Day1 Day2 Day3 GrandTotal
1 10 20 30 60
2 15 25 ...

**3**

votes

**1**answer

635 views

### Can this 5-attribute 2D risk map be built in excel?

So there is this risk map (or heat map otherwise) below (*):
What is interesting is that in the a 2D image there the following attributes are mapped:
Attribute -------- Drawing component
1. ...

**0**

votes

**4**answers

30k views

### Excel quirk: Will not create graph from certain data

I had a certain block of data in a spreadsheet I was trying to create a graph (chart) from. I spent over an hour trying to figure out what was going wrong with my chart settings. I tried cutting and ...

**1**

vote

**0**answers

7 views

### Excel stays visible when changing desktop on windows 10

I am using office 2010 on a windows 10 computer (upgraded from windows 7, office was installed prior to the upgrade)
I have a problem that occurs whenever I have two or more excel spreadsheats opened ...

**0**

votes

**1**answer

31 views

### Excel creating tables which use dates

I have a table which has dates but and each date has a corresponding cell which has a number of sales. The dates are not in order but some dates are missing and many dates are repeated. How can i find ...

**6**

votes

**5**answers

3k views

### How to combine data from two rows, when certain criterion is met

click to enlarge
I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column ...

**-2**

votes

**0**answers

20 views

### Excel VBA - Combining daily data into monthly data [closed]

I am very new to VBA. So, my problem is that each day I have a file containing a list of products (with their respective code) with their total volume sold and the value of each product sold ($).
I ...

**6**

votes

**5**answers

39k views

### Diagnosing slow Excel spreadsheets?

A client contacted me, complaining of Excel spreadsheets that were taking far too long to open. They use Excel for creating invoices, so they have hundreds of Excel spreadsheets with light formatting ...

**0**

votes

**2**answers

6k views

### Fatal error in excel “Errors where detected while saving filename”

I have some of excel files and I got an error while saving that says "Errors where detected while saving file name. Microsoft Excel may be able to save the file by removing or repairing some features. ...