The 2010 version of Microsoft's spreadsheet application.

**-4**

votes

**0**answers

16 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

**0**answers

15 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

**2**answers

34 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

**0**answers

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

**0**answers

18 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

**0**answers

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

**1**answer

36 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

**0**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

19 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

**1**answer

41 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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

37 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

**0**answers

22 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

**3**answers

24 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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**0**answers

15 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

**0**answers

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

**2**answers

30 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

**2**answers

68 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

**3**answers

42 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

**1**answer

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

**0**answers

26 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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**0**answers

18 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

**2**answers

38 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

**2**answers

47 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

**0**answers

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

**1**answer

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

**-1**

votes

**2**answers

54 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

**2**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

27 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

**1**answer

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

**1**answer

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?