The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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