The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
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
1answer
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
3answers
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
1answer
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
2answers
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
2answers
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
1answer
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
2answers
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
3answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
4answers
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
0answers
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
5answers
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
2answers
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
1answer
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
3answers
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
3answers
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
3answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
1answer
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
4answers
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
0answers
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
1answer
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
5answers
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
0answers
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
5answers
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
2answers
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. ...