Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X as part of the Microsoft Office suite. A new user-interface design, dubbed the "ribbon", was introduced with Excel 2007 for Windows. A similar UI was introduced to Excel 2011 ...
2
votes
3answers
37 views
How to sum up numbers conditionally in Excel?
I have the following Excel document, which tracks hours needed to implement various tasks by the development language (c#, sql, vb6):
In the cell E8, I'd like to calculate the total amount of hours ...
0
votes
1answer
32 views
Formula in Excel graph
I am creating a line graph in Excel 2007. What I would like to achieve is to specify a formula in the chart data range.
What I have now in the chart data range is:
...
0
votes
1answer
22 views
How to autofill a column with a single text and making it read only?
I need to create an Excel file where the first column of every row should be a fixed text string.
This column should not be editable.
The reason for this requirement is that the user can save this ...
0
votes
1answer
47 views
How to get the difference between two dates based on an item (truck) number
I'm trying to set up a database for a co-worker to track information based on truck number, amount disposed, etc. Sometimes trucks are left with garbage at then end of the day. That truck may not be ...
1
vote
2answers
42 views
Why does Find in Excel give unexpected results?
I would like to find all cells containing the number 18 in an Excel 2007 worksheet where the numbers are in a column with entries in General format (both numbers and strings).
When I use the Find ...
2
votes
1answer
37 views
How does Service Pack 3 for Excel 2007 show up in “About”?
That is, if you know for a fact that SP3 for Excel 2007 has been installed, how does notation of its existence in your system read out under Office Button!Excel Options!Resources!about Microsoft ...
0
votes
2answers
29 views
Sheet duplicating
I want one excel work sheet to be sitting in a public folder of Dropbox, and I want this sheet to be an identical version of a sheet in a differrent workbook. Is there a way of making one sheet ...
4
votes
1answer
76 views
Excel “super duper” vlookup formula needed
If I have the following data:
123, thomas
123, gordon
123, smith
334, joey
334, nancy
3452, angela
3452, liza
I want a formula to produce the following results:
123, thomas, gordon, smith
334, ...
2
votes
3answers
98 views
Autofill a Cell in Microsoft Excel
I am using Microsoft Excel 2007 and have a few different cells. One cell is going to have the same data for every cell. I have another which will be numbered 1 - whatever, Example:
Column A ...
1
vote
1answer
114 views
Auto completion in a drop down list in Excel 2007
Issues: I have a list of many names on sheet 1 of a work book.
This list of names is used via a drop dawn list in sheet 2 of same work book but please note that only the one needed at any point in ...
0
votes
3answers
81 views
Make numbered list with update feature?
Is it possible to do something like this in Excel? Like a list of active rows with an ordinal number in them.
There is a column B. It needs to show an ordinal number which represents the active row ...
0
votes
2answers
220 views
conditional formatting in excel 2010
I have some strange problem, after I've made switch from excel 2007 to excel 2010 I've started to receive duplicates of conditional formatting rules in excel. For example: I have conditional ...
1
vote
3answers
87 views
In MS Excel 2007, replace numeric value with same value plus function
For example, if Column A contains:
123
456
789
I want to replace values with:
=(123/60)
=(456/60)
=(789/60)
I know I could create another column to do something similar, but would rather know ...
2
votes
1answer
121 views
copy excel cell copies carriage return also
I am copying individual cells from excel and pasting it into SQL. Each time I do it, carriage return is automatically added to copy.
Repro:
Enter 123 in any cell in excel 2007.Click on another ...
0
votes
3answers
90 views
Excel formula to bring back one of two values based on another cell being populated or Null
I am trying to create a formula that will reference a cell. If that cell is blank, I want it to bring back a value of "LTL Direct". If it is not blank (anything at all showing), I want it to bring ...
2
votes
1answer
112 views
Need a different “INDIRECT” function in Excel
I have a spreadsheet that has about 16 equations that use ranges.
I want to be able to copy the data and equations for multiple runs of the data. With different runs of the data, the ranges are ...
1
vote
2answers
200 views
Excel: Merge two tables based on one column
I have two Excel 2007 sheets A,B with the same columns.
B contains less rows, but has a column with updated data (i.e. data in this column is newer than in the same column in A). I want to take every ...
0
votes
1answer
116 views
How to password protect multiple Excel 2007 files with multiple passwords using a Macro?
I'm new here so please let me know if my post is incorrect or anything like that.
I currently have a macro that splits out one excel file into multiple files and saves them separately. This step I ...
0
votes
0answers
17 views
Convert To Range - dynamically grab tablename
I found the following post on this site.
ActiveSheet.ListObjects("TableName").Unlist
Problem is that I get different tables and I don't know the tablename. I know that A2 will always be a part ...
0
votes
1answer
67 views
Launch executable from Excel 2007/2010 context menu with contents of cell as argument
For both Excel 2007 and 2010. I want to right click on an cell and have one of the choices be "Run Slump". And when the user chooses that, it will launch the executable:
...
0
votes
1answer
123 views
Comparing two columns in Microsoft Excel
I'm attempting to compare two columns of data. One column (column G) is a "master" list with all account numbers in it and the other column (column A) only has a partial list of account numbers.
I'm ...
0
votes
1answer
44 views
MS Query unresponsive after launching in Excel 2007
User is launching MS Query from within Excel 2007 querying a database and then MS Query becomes unresponsive staying minimized to the task bar. Any assistance would be appreciated, the user is able to ...
0
votes
1answer
287 views
Excel INDIRECT function and conditional formatting - highlighting a row
I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
0
votes
2answers
149 views
Lookup Multiple Results for Multiple Criteria
I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
0
votes
0answers
15 views
MS Query launched from Excel 2007 stays minimized to task bar [closed]
Possible Duplicate:
MS Query unresponsive after launching in Excel 2007
I am trying to assist a user who is launching MS Query from Excel 2007, MS Query then launches but stays minimized to ...
0
votes
1answer
29 views
Auto updating similar formulas
I'm trying to see if there's a way to get my Excel sheet to auto update with new formulas as I enter it.
For example if D4 down to D27 was the same formula(=SUM(B4/25)) and I wanted to change it too ...
0
votes
1answer
52 views
merging duplicates and merge into rows for excel 2007
I wish to do the following but not sure how to do it...Can help on this?
Original
Column1 Column2
TitleA 123
TitleA 345
TitleB 888
TitleC 567
TitleC 789
After
...
0
votes
0answers
44 views
How to stop Office 2007 from url encoding file names with #'s in them on Save As?
I can save a .ppt or .pptx file in PowerPoint 2007 with a '#' sign in it with no problem. For example:
Presentation #1.ppt
But if I then do a Save As... to change the format from .ppt to .pptx or ...
0
votes
1answer
31 views
Excel 2007 How To Reference A Seperate Cell In WS1 From A Common Cell In WS2
I have a simple file with two worksheets in. In the first worksheet (a product list) are a number of columns, including Product Code and Product Description. In the second worksheet (dispatches in ...
0
votes
0answers
26 views
How can I make results of a formula values that can be filtered or use vlookup with Excel
I am having an issue in that I am using various formulas to move, split data, etc from various sources. The problem is when my final results post to the final destination that I want, I still need to ...
0
votes
2answers
69 views
Excel: How to print unique pages with only one sheet
I am trying to create a template in MS Excel to print similar pages but with an unique ID within each printed pages (e.g. ID: 001, 002 and so forth) but printing from one sheet only.
I am creating ...
2
votes
2answers
38 views
Excel Issues macro may be needed
I trying to compare lists in excel. There are two lists, one list just has one column and the other has two columns, and what I am trying to do is when column A matches column C than take the value ...
0
votes
0answers
93 views
In an Excel calendar, how can I create a calendar event for a date based on an entry for another date?
Sounds a bit confusing, doesn't it?
I've created an 'events calendar' in Excel for my local area. Each date throughout the year is assigned to a row.
What I want to do is, when I enter an event for ...
2
votes
2answers
191 views
Excel Conditional Formatting
Highlight all non-blank entries in a column, except for the column header, that do no fall in some range.
Here's my attempt:
...
0
votes
3answers
111 views
Microsoft-excel newlines and tab
Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...
0
votes
0answers
68 views
HTML interpreter or module/addon for Excel 2007-2010
I need to edit a database, which I have exported from my webpage. (So later, I can import it again, to refresh the database. It's much easier to edit it offline, with some application like Excel.) The ...
0
votes
1answer
62 views
How to scale a value entered in excel?
If I enter 123456, it should be displayed as 1.23456. However, the value stored internally should still be 123456.
Is this possible in Excel? Thanks for your time.
1
vote
1answer
70 views
Combine cells with binary values in Excel
imagine I have a couple of eight cells which all contain a binary value; so it shall be something like Cell A1 has value 0; Cell A2 has value 1; Cell A3 has value 0; etc.
What I would like to have is ...
0
votes
3answers
969 views
Copy Excel worksheet and maintain relative cell reference in formulas
Another copy problem in Excel:
How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
1
vote
2answers
191 views
Count negative values within date range (month)
I have values in a table like this
Date Values
01/01 5:35
02/01 -7:08
02/01 3:45
15/01 -4:05
02/02 3:25
13/02 4:25
19/02 6:20
I would like to count by month how many 'Values' ...
2
votes
1answer
110 views
IMEI number formatting in Excel
I'm trying to format IMEI numbers in Excel according to RIM (Blackberry) conventions: XXXXXX.XX.XXXXXX.X
I enter them in excel without any periods and use the "special format" cell properties so it ...
1
vote
1answer
127 views
How to draw a 'sane' scatter plot in Excel?
I've been at it for over 2 hours now and am just a bit flustered :)
I have the following data (for example):
Label | Criterion 1 | Criterion 2 |
A1 | 7 | 3 |
A2 | 1 ...
1
vote
2answers
516 views
How to combine multiple rows of data of a single customer in a cell as comma separated values?
I have a PIVOT table report like the one below:
Customer Name Category Date Met
-----------------------------------
Customer 1 Core 9
10
Customer 2 ...
3
votes
3answers
619 views
How to combine values from multiple rows into a single row in Excel?
I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this:
...
1
vote
1answer
146 views
Auto: enable automotic update of links Ms-Excel?
How do I enable automatic updates of links for all users, even on other PCs?
I have more than 20 excel sheets that are all linked and need to update.
The problem is that sometimes users forget to ...
0
votes
0answers
61 views
Excel 2007 - can't use “Close Group” from taskbar
I have several .xls files open in Excel 2007 (OS is Windows XP). When I right-click the Excel group on the taskbar then "Close Group" is not available. Why?
It does not matter if I have worked with ...
1
vote
2answers
112 views
Can I use “Fill Down” to make a vertical series reference a horizontal series?
Say I have a data series going from A1 to E1. I would like to make a second copy of these cells going vertically, for instance from G1-G5. I can achieve what I want just by typing =A1 into G1, =B1 ...
3
votes
1answer
174 views
Are Excel linked paths relative or absolute?
Let's say I have a group of XLS files in a folder, and I want to link the tabular data in them to a new XLSX so I can graph it.
If I move the entire folder to a different path, computer or storage ...
0
votes
0answers
165 views
Code for VBA Excel to make report(summary) in MS Word
I want to create vba/macro in Excel which could make a report in Word from my calculations in Excel. In short, it is truss calculations throughout many pages, but I need to copy all calculated data ...
1
vote
2answers
194 views
View linked Excel 'Windows' on separate screens
A colleague had a problem where he couldn't link a cell in his destination workbook with a series of cells in a source workbook. The problem was that in order to link workbooks, he had to open them ...
