The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

-4
votes
0answers
11 views

Can you create a duplicate of a workbook, but I need to Edidt WBA and I want WWB to change as I edidt WWA. IS that possible??? [on hold]

Can you create a duplicate of a workbook, but I need to Edit WBA and I want WWB to change as I edit WWA. IS that possible???
0
votes
0answers
12 views

Web queries have slowed down after updating Excel 2003 to 2010

I built an excel workbook in windows XP. Using excel 2003. I have moved the file to excel 2010 on Windows 7 enterprise. The workbook has about 20 web queries. I had no problems in the earlier ...
0
votes
2answers
31 views

How do I categorize a list?

I'm looking to categorize/sort a list by matching certain strings. I previously couldn't find a solution so hopefully this way is easier. Example list: [A] The apple is the pomaceous fruit of the ...
0
votes
0answers
8 views

Excel 2010 - Need to pull data from column and place it in the exact row that matches the UserID

So I have 2 different workbooks. I need to pull the one column of data over to the master WB and match up to the User ID I have. Example: WB1 UserID1 computer1 Primary1 WB2 UserID1 computer1 (need ...
0
votes
0answers
17 views

Excel Table Copy Wrong Formula with Newly Inserted Rows?

I am trying to create a simple spreadsheet to track costs. I have a total of five columns with different categories, two of which have formulas. I wanted to be able to insert a new row into the ...
-5
votes
0answers
15 views

I want to know the macros VBA command line for linking cells in an excel workbook [on hold]

Please am supposed to use macros to link cells in a workbook but appear to have a problem recording it. so i would appreciate it if someone can just give the VBA lines so i can iput them. Thanks in ...
2
votes
1answer
31 views

Excel Help: How to scan a row and return the value of the first cell in that column

I have a matrix of numbers and the matrix has column header -- say like this: a b c d e f 0 0 0 1 0 0 0 0 1 0 0 0 What I want to do is to search for each row for the element 1 and return its ...
0
votes
0answers
6 views

Delay in running Background Queries in Excel 2010

From the time I open the file it takes 6 minutes before the background queries finally run. These are just simple data from the web queries that worked great in the 2003 version.
-2
votes
0answers
6 views

If Statement between 2 worksheets

On Sheet two titled "Talents" cell b5 I need an if statement that does the following: if cell b5 on sheet 1 titled coremembers has an x in the cell then cell b5 on sheet 2 titled talents is equal to ...
0
votes
2answers
26 views

How to write the cells in rows one under the other in columns?

I have a list of name, company, phone number, address and e-mail. But each name who works at the same company is in the same cell. Of course, the other informations of those names like phone number, ...
0
votes
1answer
11 views

Converting text data into time in excel

I have a coloumn in excel wherein time has been entered as text i.e.,2:50AM . Now I would like to convert that into time format. Kindly advice how I can achieve it.
1
vote
1answer
17 views

Excel Conditional Formatting Colour Scales highlight group of cells when another cell is a certain value

So I have a document that has 2 drop downs with the first acting as a currency selection and the other acting as a discount selection (0% - 50%). Basically whenever I select from the dropdowns the ...
-1
votes
1answer
40 views

How to write Excel macro to copy selected row of data between two sheets?

I'm not really experienced in the whole VBA area, i get how macros work but this is just out of my reach. Basically as i stated in the title i need to write a macro that will copy the selected row or ...
0
votes
2answers
17 views

In Excel 2010, how do you format text to string without having to open and enter on every single cell?

I was given an Excel document. In the data there is a column of dates formatted 5/20/2014. Half the data in that column is formatted as a date. The other half is formatted as text. When I try and ...
0
votes
1answer
18 views

In excel, add up a column so that each row in a new column shows the sum of the other column for all previous values

I want to add Column A so that it results in Column B, I've tried the Sum and SumIf function in Excel. Column A : Column B 0 0 0 0 0 0 4 4 8 12 ...
0
votes
1answer
25 views

Creating GANTT Chart (Timeline) From Start Time and Duration

I am attempting to create a daily graphical timeline from start times and duration. I have three columns: Program Name, Start Time and Duration. The data looks something like this... The desired ...
2
votes
1answer
22 views

With PowerPivots, find items that appear *only* in one category

With PowerPivot, how do I find items only in one category? Here's an example: item category number obera f6 7 artois f7 2 obera f7 3 ella f6 9 If ...
2
votes
0answers
33 views

excel 2010 not inheriting regional settings in windows 8.1

Wondering if anyone else is having this issue. In regional settings on Windows 8.1 i have display negative numbers set to display in accounting mode. eg - (1.0) instead of -1.0 Excel should be ...
-1
votes
0answers
21 views

2 Excel Tabs: Find matching values in column As and match the B columns based on A. (Only one tab has B filled)

I have two tabs in excel; one working with technologies and one with patents on those technologies. The technology tab has each tech ID in column A, and the patent tab has the same tech ID numbers but ...
1
vote
3answers
23 views

Using OR condition in SUMPRODUCT

I have three columns of data - a sum column (A) and then the two columns that form the sum (B and C). Sometimes, just one of the B and C columns is filled in; occasionally the B and C columns are both ...
-1
votes
0answers
17 views

How do I add a column in a pivot table?

I have a pivot table with a timescale, i.e. account names from top to bottom and months (jan to jun) from left to right. Now the last column gives me the sum of the 6 monthly figures which i need. I ...
0
votes
1answer
18 views

Text function in Excel isn't formatting year

I've got a problem with the text function in Excel (2007). It doesn't format the year, it just states yyyy instead of e.g. 2014. If I have a cell with 23-7-2014 and use the formula ...
0
votes
3answers
32 views

Compare 2 columns in Excel and copy data from 3rd column

I'm trying to compare 2 columns that don't have the same size (one has 205 entries, the other 440) and if the data from column B matches the data in column A, the data from column C must be copied in ...
0
votes
1answer
15 views

CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...
0
votes
0answers
14 views

Refreshing “MSN Money Central Investor Stock Quotes” asks for stock symbol, but does not get new price

I have set up spreadsheets in MS Excel 2010 that pull stock quotes from 'MSN Money Central Investor Stock Quotes'. I try to refresh/update the quotes by clicking on the cell where quote/price is ...
0
votes
0answers
25 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 ...
-1
votes
2answers
28 views

Excel 2010 Conditional Formatting - TIME

I need to make a spread sheet with conditional formatting. I don't know how to go about this. What i'm trying to do is Check in Times. So Bob Will depart our shop at 8:00AM and he will check in with ...
0
votes
2answers
66 views

Calculating time difference between two date/times from two columns in Excel

I have 5 columns: Start Date, Start Time, End Date, End Time and Duration. I need to calculate the duration between the Start Date/Start Time and the End Date/End Time. I tried just subtracting the ...
0
votes
3answers
41 views

In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data: item category number apples fruit 7 orange fruit 2 tomato fruit 3 tomato vege 9 zuchini vege 2 tomato vege 17 ...
0
votes
1answer
27 views

How can I find all cells in Excel with a particular value and get the sum of all those cells' dependents?

I am trying to find the total number of screws, nuts, washers, etc for a very large assembly. For each part in the assembly, I have the number of each type of hardware. I would like to find the total ...
-1
votes
0answers
25 views

Micro Excel 2010 Highlight changes made by Macro

I have two workbooks set up, one with all the calculations and the other that summarises and 'cleans up' the appearance. I have a macro set up that copies all the values from the one workbook to the ...
0
votes
1answer
17 views

Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations. When I open the .csv file the ...
1
vote
1answer
15 views

How to remove one column of a calculated item in Pivot?

I have two columns. One with data from this year and the other with data from previous year. I now have added a calculated item in Pivot to display the % delta of these two years. Now when doing this ...
0
votes
2answers
39 views

How do I find the next smallest/largest value without sorting?

I have a table from which I need to pull the next largest and/or smallest value, relative to a value in a separate table. However, I also need to allow the first table to be sortable by any criteria, ...
1
vote
1answer
32 views

A formula to check if the date is older or equal to 60 days and another columns cell is equal to a value

I have tried using conditional formatting and managed to get the first part of the formula to work. =D2:D999<=TODAY()-60 I want to then also check if the value of what is in column G is equal to ...
0
votes
0answers
17 views

How to Group and Layout Pivot Table when Values is in the Row Labels Field?

I'm attempting to present large amounts of data in a report using a Pivot Table to allow for dynamic filtering/categorization. The data in the table is of the form: Year Month Category Region ...
0
votes
2answers
37 views

Excel bar graph, easy idea, hard implementation apparently

I want to make a graph like this, but I can't seem to make it correctly: Data: 4, 2, 3, 4, 1, 3, 3, 2, 3, 4, 2, 3, 2, 1 Three elements: Y-axis potential values (1-4 or worst, below average, above ...
1
vote
2answers
44 views

Excel: how to permanently apply conditional formatting to the whole spreadsheet?

I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the ...
0
votes
0answers
15 views

VBA Compare columns on two diff worksheets, find in 2nd and group on 2nd worksheet

Excel 2010 Hi. I have a 6,000 line spreadsheet and need to group the lines, based on identified roll up points in another spreadsheet (150 roll up points). I want to be able to see the summary ...
2
votes
1answer
27 views

In Excel, can you create a cell that updates the number of another cell without having to hold the inputted value?

Since I can't create a form using VB or ACCESS here at work, I'm trying to figure out if I can use a cell as a makeshift form. I want to label one cell "Enter New Order Quantity." Next to it(next ...
0
votes
2answers
53 views

Excel how to divide a time period into equal time periods

I would like to find a way of dividing a period of time into 4 hourly time zones. I.e. if a piece of equipment is unavailable from 0900hrs to 1700 hrs that is 8 hours but I need to show this in 4 ...
-1
votes
2answers
34 views

Is there a formula to change the value of a call, depending on selection from drop down list?

I am trying to create a prices spredsheet. I need one column where you can choose a product from a drop down list The next column you enter the amount of units required The next column (the tricky ...
0
votes
3answers
27 views

How can I modify a lot of values easily in Excel?

I have a big file of numerical data with 600 columns and 4000 rows. I would like to be able to change the data of about 3/4 of the columns by multiplying them with 1.02. For example, let's say I have ...
0
votes
0answers
7 views

Excel Hyperlink Default File Type

Is there a way to set the default file type when inserting a hyperlink in Excel 2010? I typically want to link a PDF stored locally... insert hyperlink (ctrl+k) > "browse for file" icon > click ...
1
vote
1answer
19 views

Creating Dynamic, Unique Arrays Dependent on Multiple Criteria or Subset of Data

I have a Table structured in this manner: City Region Date Value ABC 123 Jan1 10% DEF 999 Feb1 7% The table is fed by user-entry, but there is an important rule: ...
0
votes
0answers
13 views

Excel 2010 separating registers with the same name on dynamic tables

I have a series of registers in the form of: Name Value Other Field AAA 112 … AAA 8127 … AAA … … BBB … … BBB … … CCC … … … … … ...
0
votes
0answers
11 views

Excel workbook contains a userform which opens up black on 8.1 office 2010

The userform within the worksheet opens black on windows 8.1 office 2010, yet it opens fine on XP with office 2010. It's a excel 79 to 2003 xls file. We checked trust centre on 8.1 but no joy, ...
0
votes
1answer
26 views

Count the number of times a date occurred in a report

I need to Count the amount of times a date comes up in an excel report. The data in my report shows as follows: 7/7/2014 13:56 7/7/2014 11:26 7/7/2014 10:48 7/7/2014 9:57 7/4/2014 11:49 ...
0
votes
1answer
26 views

How can I total a Column when there is an #N/A or blank? [duplicate]

I want to be able to total an entire column. I want excel to give me the total sum of all numbers in the column and ignore the blanks and the #N/A. How would I complete this?
0
votes
1answer
21 views

Embedding hundreds, even thousands of pdf files in excel?

Would it be possible and efficient to insert - object about 1000 PDF files to an excel document, or will it start running extremely slow/other problems?