The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

6 views

### Excel doesn't show all data points

I have an Line graph in Excel 2010 displaying data on 7 areas every friday through the end of the year. The graph currently shows the data through the end of October but will not display data beyond ...

**0**

votes

**0**answers

12 views

### Evaluate Formula Gives Wrong Result

Why would the evaluate formula give the wrong result with the correct values?
In the evaluate formula window of Excel I get the final following steps.
370+27.5*(9.5)
370+27.5*9.5
370+261.25
4,725
...

**0**

votes

**0**answers

4 views

### How do i calculate 'TRUE' values across multiple pages of workbook in Excel?

I have devised Audit workbooks with up to 21 pages with Yes/No tick boxes for each question. I have linked each tick box with the Yes/No cell for each question (very time consuming) but I need to now ...

**0**

votes

**1**answer

14 views

### Advice making a multi line chart with daily count data

This is what my raw data looks like.....
raw data image
I would like to use this data to create a chart that display's Install date in the X axis, a daily sum of records for each installed by name in ...

**0**

votes

**0**answers

13 views

### Excel: Add new rows to a table with a subtotal row, when data added to a specific column on the last row

How do I get an Excel table (with a subtotal row) to automatically add a new row when I enter data in column C of the last row?
At the bottom-right of the table I have 3 cells with basic SUM formulae,...

**0**

votes

**0**answers

18 views

### NTFS - allow a user to read, write and save an .xlsx file but not delete it or create new files and folders

I would like to allow a user to work with an already created Excel workbook -say A.xlsx- in a folder. It would be able to open, modify it and save it. It can not rename /delete it or other files nor ...

**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

**0**answers

25 views

### EXCEL. An array that displays the most recent set of data(based on date) of a customer

I'm looking to pull data from one sheet into another sheet where I pick the most recent date of information on a person. So I may have 50 entries for Bob, but on sheet 2 I just want to post the most ...

**-2**

votes

**1**answer

13 views

### how to find and highlight similar texts in Excel 2010

I am not pro in Excel. I have an excel table that I need to find similar values and highlight the the remaining texts.
I have read some questions here but it was not helpful in my case.
I would ...

**1**

vote

**0**answers

26 views

### Conditional formatting with several conditions depending on different cells

I currently have a table in excel that looks like
.
The table shows four projects, each with three stages with each having an expected and actual start date for that stage.
I want to create a ...

**-1**

votes

**0**answers

9 views

### Parse Excel to xml using vba using Excel column data as XML attributes

I have an Excel table with data in column1 and id's to this data in column2.
column1;column2
dataCol1Row1;dataCol2Row1
dataCol1Row2;dataCol2Row2
Using any of the VB examples given in Parse Excel ...

**1**

vote

**1**answer

156 views

### Parse Excel to xml using VBA

I have VBA code that wirtes an Excel table to an xml file (actually writing the xml file line by line, tags equal column headers).
This is the code, it is quite straight forward.
Sub MakeXML(...

**0**

votes

**2**answers

2k views

### SUM From Sheet 1 Columns to Sheet 2 Rows

Tried searching for a while, didn't see what I was looking for.
On Sheet1, I have approximately 100 columns, each representing an item. Each row is populated by a quantity of that item. As you can ...

**0**

votes

**1**answer

15 views

### Excel Convert Time with units

If I have a cell with time data formatted as "1m 11s", how can I convert this to something excel can understand?

**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

13 views

### Excel table formatting for alternate row colours that get inherited

I have an excel table formatted to use excel table design which has alternate colours on rows. When I click in a cell and select insert table row above or below; I get a new row but the alternate ...

**0**

votes

**0**answers

9 views

### How do I assign a dollar value to a word in a specific cell?

I am trying to assign a dollar value to a cell titled "internal bridge." Cell B4 (Internal Bridge) should equal $500. In cells B5 - B18, I intend to use number values (1-50) to represent the number ...

**4**

votes

**3**answers

32 views

### EXCEL HELP in transposing the columns to rows

Input :
MACK 113 445 25
JACK 345
PIKER 30 23
I want the output to be :
MACK 113
MACK 445
MACK 25
JACK 345
PIKER 30
PIKER 23
Can anyone please help me out . ...

**0**

votes

**0**answers

13 views

### How to tell which labels have been changed in a pivot table?

I'm working in Excel 2010 with a few pivot tables where I think some wrong edits were made on row labels. I need to find the edited labels, check them for mistakes and correct the wrong ones.
The ...

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

**0**

votes

**1**answer

11 views

### Creating a For All function in Excel

This might be hard to explain, but I am trying to create implement a formula that compares a bunch of values of "TRUE" or "FALSE" and then displays an output a corresponding cell that states if at ...

**2**

votes

**2**answers

13k views

### Delete default template in Microsoft Excel 2010

A default template has accidentally been made and continues to open on start up of Excel. How can I delete a default template in 2010?

**1**

vote

**1**answer

257 views

### Header in Excel 2010

I need to add a special header in Excel 2010. It's the one which you can scroll down on the Excel data and the header is always visible on top. And you can see in it in Normal View.
Actually, I think ...

**-1**

votes

**1**answer

251 views

### Excel, No longer receive the option to open files in a different format

I have a web app that saves files as .xls but are actually well formatted .html. The files have always opened with excel producing the following warning:
The file you are trying to open 'file.xls', ...

**0**

votes

**2**answers

89 views

### Why do I have to hit tab twice to Alt+Tab away from Microsoft Excel?

In other apps, when I hit Alt+Tab it switches to the previous app. Before I actually release the Alt key I can see a list of windows as well and the previous windows is selected. But in Excel 2010 (...

**1**

vote

**2**answers

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

**3**

votes

**5**answers

6k views

### Paste html into Excel 2010 without Excel parsing the html

I'm running a query on SQL. Typically I can easily copy and paste the results from the query into Excel and it preserves the columns, rows etc.
However, in this case I'm selecting a bunch of emails ...

**0**

votes

**0**answers

39 views

### Getting data from same row as matched cell on separate sheet

I need to match A2 with Sheet2!A:A, but the value I need is a cell on Sheet2 in the same row as the match.
Let's say A2 matches Sheet2!A20. I need the formula to return what's in Sheet2!E20.
I ...

**0**

votes

**1**answer

37 views

### Get distinct count based on different parameters

I need to get the distinct count (how many times does a unique value occur) based on a few parameters. The table looks similar to this:
Getting the Amount is not a problem, I use SUMIFS() with a ...

**0**

votes

**0**answers

14 views

### Defining a range in excel for index/match

I'm trying to return a "best" value, but there are two criteria for a threading calc. One column has stress, which just has to be higher than a given value, and the other would be where you want the ...

**-3**

votes

**0**answers

15 views

### Get data in MS Excel from Active Directory

I want search data in activer directory from a value excel cell, like I have user ID in excel sheet want to retrive frist name and last name of that user ID. Can someone help me to resolve this? Using ...

**-2**

votes

**0**answers

11 views

### Excel pivot table grouping

I'm using excel 2010 and I want to create a pivot table that shows times between breakdowns in groups of 1 hour. The problem is that no matter what I try I get the cannot group selection error. I ...

**0**

votes

**1**answer

26 views

### cannot find any saved .csv files

I did search through many of the .csv realated topics that the search returned so I hope this is an appropriate new question...
I am trying to setup an excel spreadsheet using a .csv file as the data ...

**1**

vote

**2**answers

53k views

### Comparing two columns in different Excel spreadsheets

I have two Excel spreadsheets. In the first spreadsheet I have two columns. Column A has 240 Accounts entries and Column B has Values for each account entry. Once again Spreadsheet 2 has its data in ...

**6**

votes

**5**answers

4k 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 ...

**0**

votes

**1**answer

4k 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 ...

**-2**

votes

**0**answers

38 views

### Excel - Auto Populate Break Schedule based on Weekly Schedule [on hold]

Ive been racking my brain trying to figure this out, ive searched and searched and I guess I just dont know enough about excel to be able to do this.
I have 8 sheets to work with, The first one is ...

**0**

votes

**4**answers

71 views

### Can Excel update sheet reference (like it can with cell) when I paste content of one sheet to another?

I have a document where I create a new sheet which represents days (has to be that way). Each sheet has a reference to the same cell in the sheet that represents the previous day. So sheet "Tuesday" ...

**1**

vote

**1**answer

22 views

### Excel: Compare multiple columns to see if less than value in another column for all rows

I am trying to compare data across multiple columns to see if each cell is less than a value in a single cell on the same row.
Column B contains the mean across all employees for the variable in ...

**-2**

votes

**0**answers

14 views

### How to automatically transfer Excel data with no fixed cell reference to a new worksheet or workbook with specified fields

How do I AUTOMATICALLY transfer mixed data to go to specific fields in a new worksheet or workbook.
All the Excel data are on separate worksheets.
The columns and rows are not similar.
The lables ...

**0**

votes

**1**answer

36 views

### Separating Names In Excel

I have a list of 60K names. I need to separate them into different worksheets based on their length.
I have been doing it using normal way using len() formula, filter them and copy paste them to ...

**0**

votes

**1**answer

15 views

### Mailmerge 2 spreadsheets

Can I mailmerge in Word 2010 using 2 Excel spreadsheets? Have found article that says Get Data and then click Data Source but cannot find this in Mailmerge Wizard as an option.

**0**

votes

**0**answers

44 views

### without iteration condition, =A1+C1 in C1 cell,

I've tried iteration condition, but it is not taking only the 'A1' value, if I put some value in some other cell, C1 is calculating like =A1+C1 in C1 cell,means
A1 value is 5, in C1 i put this farmula ...

**0**

votes

**3**answers

20 views

### How do i align multiple columns in excel by name and sales?

Please ref attached image.
I need to align sales for the agents in single row to match their names. The problem is that in Jan the number 1 agent may be on 5th spot and in 12th place in the third ...

**0**

votes

**2**answers

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

**-1**

votes

**1**answer

31 views

### figuring Golf Handicap

Presently we use the following formula and it works great:
=IF(COUNTIF(D4:AB4,">0")<3,C4,IF((((SUM(D4:AB4)-(COUNTIF(D4:AB4,">0")*36))/COUNTIF(D4:AB4,">0")))*0.9>20,20,(((SUM(D4:AB4)-(...

**1**

vote

**1**answer

17k views

### If(AND) combination produces “You've entered too many arguments for this function” error

Combining around 4 If(AND) conditions giving error as
You've entered too many arguments for this function
The formula is here:
=IF(AND(C2 = "Low", X2 <= 168), "Met", "Not Met",IF(AND(C2 ...

**1**

vote

**1**answer

22 views

### Excel Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns

Here's a simple explanation of what I'm having trouble with.
Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns.
SUPPLIER A
F4: PRICES SUPPLIER A
...

**-1**

votes

**0**answers

10 views

### How using (office 2016) Excel VBA, Auto copy and/or save a web page image

EXCEL 2010. After navigating to a web page using Excel VBA I wish to copy an image into excel AND/OR save it to a documents folder IE:
<img alt="" src="/images/rp_251x251/Product/94031/...

**0**

votes

**1**answer

19 views

### How can I remove a cell from a range for a property lookup array

Lets say I have a value, A123456, in a column A, row 1, and i want to check if I have the same value in other rows of the same column, regardless of the length of the values as long as it has the same ...