The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
4 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
20 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
11 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
13 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 ...
-1
votes
1answer
25 views

How to search for all Excel files in a folder with value X right next to value Y?

Situation I have a couple hundred Excel files in a main folder with subfolders. Question Is it possible to search all Excel files not only for one value X but for one value X next to value Y? What ...
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
35 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
28 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
12 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
29 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
32 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
11 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
25 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
42 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
31 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
5 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
14 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
12 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
8 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
24 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
20 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
0answers
15 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
1answer
12 views

Array Testing of an Entire Column

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
1answer
12 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
0answers
19 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
0answers
18 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
0answers
14 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
0answers
22 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
1answer
54 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
1answer
29 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
2answers
22 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
1answer
20 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
1answer
24 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
1answer
20 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
1answer
37 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
0answers
14 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
2answers
22 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
1answer
28 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 ...
-1
votes
0answers
11 views

Excel Query How to refer to the last value found in a cell that is somewhere above the current cell

I need help with a formula that can do the following in column W. (if you can see the image) spreadsheet ok I have 2 columns: column N records a "W" or "L", column W is recording the no of attempts ...
0
votes
1answer
23 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
0answers
22 views

comparing 2 columns in excel and return the same result in a group

hi m new in excel function, i have a problem like this. i have 2 lists of data DATA I NAME SCORE ----- ----- ANA 10 BUDI 20 TINA 30 DATA II NAME SCORE ----- ...
-1
votes
1answer
23 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
1answer
14 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
0answers
21 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 ...
-3
votes
0answers
24 views

How can I get Excel to auto-fill a column based on text entered in another column? [on hold]

I am looking to Format a column of text in excel for example A ABC123 123DGF ABC124 NMO445 B Corp Acct Corp HR I want excel to notice the text entered in column A and then ...
0
votes
0answers
12 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
1answer
20 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 ...