The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**3**answers

48 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

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

**0**

votes

**1**answer

27 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

29 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

55 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

60 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

34 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

54 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

75 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

31 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

32 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

78 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

47 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

31 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

18 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

53 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

16 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

32 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

30 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

32 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?

**0**

votes

**0**answers

16 views

### Hyperlinks to documents have changed

I have several hundred links to documents in a folder on a network drive embedded in my excel so that if I click the link, the pdf document opens.
As of today, a lot of these documents do not open ...

**0**

votes

**1**answer

17 views

### Array Testing of an Entire Column [closed]

I'm looking to perform multiple tests on 1 column of data. I want the test to return Pass if every cell in the column meets the requirements and Fail if only one cell fails the requirements. I'd like ...

**0**

votes

**1**answer

43 views

### Excel 2010 “sending the command to the program” error

Multiple domain users receive the following Excel 2010 (32-bit edition) error occasionally when opening random XLS files.
There was a problem sending the command to the program
...

**0**

votes

**0**answers

32 views

### EXCEL: I have a column of single-word strings and would like to see if any of these strings are contained in a column of multi-word cells

Example:
In column A I have a list of words "Apple, Banana, Orange, etc." each in their own cell.
In column C I have a column of multi-word strings like C1="I ate an apple", C2="Bananas are gross" ...

**0**

votes

**0**answers

72 views

### VBA: how to color rows based on value in a spesific column - Coloring wrong sheet

I've been struggling with this for a while now. I need to color rows in Excel sheet 6 based on the value in column F. Everything works fine except the code is coloring the rows in Excel sheet 1! Help?
...

**0**

votes

**0**answers

22 views

### New items in drop down validation menu aren't showing in Excel 2010

In Excel version 14.4.2, I have a drop down validation menu and I have added more cells with new menu items.
However, these new items are not showing on the drop down menu on all the cells of the ...

**1**

vote

**0**answers

24 views

### How to recover some missing data in Excel?

I have two versions of an Excel file, one from before I did a lot of work on it and one from after. The after-version, despite a lot of productive work, also includes the results of a catastrophic ...

**1**

vote

**1**answer

66 views

### Excel: Different background colors on condition

The problem
I have a Excel sheet that contains a status column.
Number Status Name
-------------------------------------
1 not implemented feature 1
2 completed ...

**1**

vote

**1**answer

37 views

### How can retrieve cell address that match criteria?

In column A are various products (A2:A100), in column B are different numbers (B2:B100).
In cell G2 is criteria from column A.
With the formula {=MAX(IF($A$2:$A$100=G2;$B$2:$B$100))}, I can find ...

**1**

vote

**2**answers

41 views

### Apply VLOOKUP to multiple sheets and ignore blanks

I would like to do a VLOOKUP on multiple sheets (for which I am able to define a strict priority order) but where I want to ignore the answer when it is a blank. I have found this answer:
Apply ...

**0**

votes

**1**answer

24 views

### How to automatically delete rows that contain certain numbers in the ID column

I have a column of numbers in another workbook and I would like to use that set of numbers to delete rows in the main workbook. I will give an simplified example of what I'm talking about below. My ...

**1**

vote

**1**answer

34 views

### Unwanted space in URLS in Excel 2010

I have a list of 23000 URLs in an Excel sheet but these appear to have extra spaces in, therefore invalidating the urls.
I've tried a find and replace and excel doesn't recognise that there is an ...

**0**

votes

**1**answer

27 views

### My excell spreadsheet keeps turning 1/43 into a date.

I have tried to change it to "Gerneral" in the format bar but it changes right back to "Custom". How do I fix this? My intention is to not that this is 1 of 43 boxes not Jan-43

**0**

votes

**1**answer

47 views

### Lookup with multiple criteria and priority

I am working with different excel files which contain a lot of data from different people. I would like to do a lookup (I know how to use the LOOKUP function) but based on multiple criteria. Let me ...

**0**

votes

**0**answers

15 views

### How to link quickly to various pdf files in Excel

I have an excel database with hundreds of products. Each products is assigned a specific security PDF sheet in a folder.
Is there a way to optimize my linking routine?
My way:
Click insert - link - ...

**0**

votes

**2**answers

61 views

### Excel 2010 array formula cell selection

Suppose you have a workbook riddled with array formula.
In Excel 2007, if you select any cell (which is part of an array formula), then hit F2 to edit, you have to go ctrl+shift+enter to enter the ...

**0**

votes

**1**answer

48 views

### Microsoft Excel Custom Label Overlay on Line Graph

I have 2 tables identical.
One records the progression of projects as a percentage over dates until completion.
The other is a replica table but records the daily status of the projects on the ...

**0**

votes

**1**answer

39 views

### Excel Formula Issue Countif to Sumproduct

Having a nightmare at the moment with some formula's I've been asked to 'fix'. It would seem the users expected them to work with closed source spreadsheets but they don't. So they end up having to ...

**-1**

votes

**1**answer

24 views

### Excel formula: identifying highest weights

I need some help with the following assignment:
Task:
In the product Weight tab, you can see each product is weighted with a value per customer. Please create a Product Code for each customer based ...

**0**

votes

**1**answer

16 views

### Excel column entries modification

I have a big Excel file containing a column where I have entries of the type
A3F44
and I would like to transform them into
A3F4 - 4
in order to match them with the entries in another file. ...

**0**

votes

**0**answers

25 views

### MS ergo 4000 keyboard work with excel

I'm using a Microsoft Natural Ergonomic 4000 keyboard with Microsoft Excel 2010. The keyboard's zoom button acts as the scroll function in Excel instead of the zoom function.
How do I change it so ...

**0**

votes

**0**answers

34 views

### Excel Command Button to change Cell Focus

I have a multi sheet workbook I use for staff rostering. Each sheet is for for a 6 month period (eg Sheet 1 is Jan-Jun 2014, Sheet 2 is Jul-Dec 2014) going back to 2010.
I have the dates along Row 3 ...

**0**

votes

**1**answer

34 views

### Excel 2010 Formula of 3 variables with 3 results

I haven't been able to figure out how to combine these logic & date formulas in 1 cell.
My parameters would be:
A2 will always have a manually entered date in it
B2 could have one of three ...

**0**

votes

**1**answer

11 views

### I want a shortcut in Excel to cells I have Hyperlinked

I've built a Series of Cells which wnen concateneted = HyperLink to a remote server. Excel Wk Sheet 2010 (File name changes Daily with date function or Date User inputs)
On the same Sheet I want to ...

**0**

votes

**1**answer

25 views

### Embedded IF(OR(IF) statement

I have made a formula that basically looks for a string of text inside a cell and if it finds it puts it in another cell. I needed to check three cells so I did three separate formulas (because I'm ...

**2**

votes

**1**answer

96 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**1**

vote

**1**answer

50 views

### How do I copy an excel sheet embedded in an outlook e-mail into an excel worksheet?

I was sent an e-mail with some data from an excel sheet embedded in it. I want to extract that data to another Excel spreadsheet. When I try to copy and paste it, it insists on pasting it as an object ...

**0**

votes

**0**answers

22 views

### Multiple series plots with data in same column

I have data in excel in the following format:
Series ID: 1100 1100 1105 1105 1105 1108 1207 1207
Days X: 23 45 10 25 85 43 27 35
Value Y: 0.23 0.31 0.14 0.21 0.34 0.32 0.27 0.29
...

**0**

votes

**1**answer

10 views

### Number format in excel

How to keep number format as is in excel if the number length is more than 15.
I see that any number above lenght 15 is getting converted to scientific format and finding difficult to compare using ...