Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.
2
votes
1answer
42 views
How to automate transforming a table into a matrix
I've been looking for a way to automate transforming data in an Excel table into a matrix.
For example, from the left table into the matrix on the right, as shown in the following image:
Apparently ...
0
votes
1answer
19 views
Same cells (formatting, formulae and all the rest) across 32 sheets
I need to have the same headings for the daily report table (31 sheets in one file and a 32nd one for totals). From time to time I need to add a column, or change formatting.
Is there a way I can ...
0
votes
1answer
35 views
Is it possible to build a cumulative formula that will sum on new worksheet added daily?
I have a worksheet that the user opens each day and clicks a button that copies the current sheet to a new sheet and renames (Day 1, Day 2, etc.).
I want to keep a cumulative count in some of the ...
0
votes
2answers
62 views
How do I separate three different phone numbers concatenated in one cell into three new rows?
I am doing work for a client and need to know how to separate these phone numbers.
I have
0121 396 0501 / 0121 123 434* / 0797 978 8265
in one cell and I want to end up with the same row ...
0
votes
1answer
45 views
Merge multiple tables by comparing multiple rows
I have multiple three column tables that share two rows in common:
DailyCosts: DailyPrices
CodeRole CodeRegion DailyCost CodeRole CodeRegion DailyPrice
1 1 ...
3
votes
1answer
48 views
Permanently increase 'Recent Documents'
I've tried to look around for a similar question but it didn't seem as though there was one, so here's my case:
I've tried to increase the number of recent documents in MS Word/Excel for a while now ...
2
votes
1answer
31 views
Excel visual basic function across workbooks?
This seems like it should be a common issue, but I couldn't find anything on it, maybe I'm just searching for the wrong thing.
Basically I get sent a lot of workbooks that need specific modifications ...
-1
votes
0answers
45 views
Format multiple sheets with irregular headers in Excel
I am trying to format a price list from a supplier for import into my own database. The workbook the supplier generates contains multiple worksheets each with the same columns of data that I want to ...
-1
votes
0answers
24 views
EXCEL EMBED CAPABILITY: can the embed link be manually entered?
I can manually enter a HYPERLINK into a cell, e.g.
=HyperLink("\FileLocus\FileSpec.Ext","LabelText")
but cannot similarly enter =Embed("\FileLocus\FileSpec.Ext","LabelText"). My need to do this is ...
-3
votes
0answers
39 views
In Excel 2007, why must I click the title bar of an open spreadsheet to bring it to the front? [closed]
I'm using Excel 2007, and when there's a spreadsheet window behind another spreadsheet window that I want to bring in front, I can click the side of the covered window, but it doesn't bring it in ...
0
votes
3answers
37 views
Counting occurrences in first column of a file in Excel
I need code to find duplicate numbers and continue to count the number of times the duplicate was found.
Example: I have 20,000 entries and 303 unique numbers. I need to know how many times each ...
1
vote
1answer
40 views
Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column
I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success.
Basically, I would ...
0
votes
1answer
38 views
Using the advanced filter in Excel
I have 40 rows in Excel starting with a SerialID in sheet 1. In sheet 2 i have 109 rows which I would like to filter based on sheet 1. Sheet 1 contains records i want to hide from sheet 2.
0
votes
3answers
71 views
How do you add extra value to a cell that already has an existing number in it
I find this hard to explain, but I'm stocktaking beers, spirits, and liqueurs and I want to keep one column for my ullage count for each product. However, as I go through the days, I often come across ...
2
votes
1answer
44 views
Calculating mean of value across random trials/refreshes in Excel?
Say I have a 1000 cells filled with random values and a particular cell that computes a final answer based on those 1000 values. Now I wish to track the value of the answer over 1000 trials i.e., I ...
1
vote
2answers
67 views
Excel: how to convert a table with daily dates to weeks
Have an excel file that tracks daily dates against a daily metric.
What I'd like to do is convert the table into weekly metrics. Is there an easy way to do this, perhaps with pivot tables?
0
votes
1answer
78 views
In Excel I need to find data matches between two arrays - one horizontal and one vertical
In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...
0
votes
1answer
32 views
Issue with SUMPRODUCT Function
I am Having a issue with the SUMPRODUCT Function in Excel 2007. Here is my string and issue:
=SUMPRODUCT(($B$2:$B$800>DATE(2013,4,1))*($B$2:$B$800< DATE(2013,4,5)))
A B
1 4/1/2013
2 ...
0
votes
2answers
22 views
Row auto fit not working properly
I have one excel sheet
Width of Column A is 70 and the word wrap property is ON.
And the content in the cell is of 287 words/1950 characters.
Now when i try the row autofit function, its not working ...
1
vote
2answers
44 views
Can I use Microsoft Excel to convert a “ranged” table to a full breakdown table?
Suppose I have a spreadsheet with the following rows and columns:
QTY MIN | QTY MAX | 1 Color | 2 Color | 3 Color | 4 Color
1 | 10 | $1.00 | $1.50 | $1.75 | $1.90
11 | 20 ...
1
vote
0answers
90 views
Excel 2007: Intermittent 0xc0000005 crashes
Hello there SuperUser Hive Mind.
We are having an issue at the office I work. One of our users who has a workflow which consists mostly of Excel documents with dynamic formatting and macros which she ...
-1
votes
1answer
25 views
How to merge with macro? [closed]
From input of this kind:
CUSTOMERCODE DATE QTY
890550 16/04/2013 10
890550 16/04/2013 20
890550 17/04/2013 20
890551 18/04/2013 30
890551 18/04/2013 30
...
2
votes
2answers
196 views
How to implement MATCH and INDEX functions together in Excel VBA?
I am trying to find the row number of the first cell that is less than zero.
So, by browsing through the net I was able to come up with this formula which works perfectly fine:
...
1
vote
1answer
35 views
Exporting Data into a form type format from Microsoft Access query to Microsoft Excel Worksheet
Thanks for any help you can provide. I would prefer not to use VBA if possible, but will if necessary. I have MS Office 2007. I have a query which holds information for products that need user ...
1
vote
1answer
48 views
Using an array formula to add up several cells in another worksheet (using INDIRECT)
I have an Excel 2007 workbook. On one worksheet, I want to add up several regularly spaced values on another worksheet. I can easily do this with a very long sum formula without an array formula but ...
0
votes
1answer
47 views
Automatically updating a workbook from another workbook
I have a master workbook which I use to store all the client information I have available but I also need to generate other spreadsheets (preferably in separate files) with sub sections of the data in ...
1
vote
3answers
44 views
Merging the content of 300 cells into 1 cell
I need to send group emails. The email addresses are stored in an excel sheet in different columns. How do I merge all of the email addresses into one cell so that I can easily send group emails. The ...
0
votes
1answer
52 views
How do I add values in column B if column A contains the same employee surname more than once?
State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once?
I have been using what I ...
1
vote
1answer
72 views
Populate a table based on various inputs
I have three simple inputs for a quotation we're preparing, and I would like to automatically calculate all the possible combinations.
For example:
We need to produce Small, Medium, Large and XL ...
1
vote
0answers
29 views
Pivot table Grand Total calculates incorrectly [closed]
Does anyone know if there is a solution/fix for article ID: 211470 issue?
http://support.microsoft.com/kb/211470
Thanks,
Don
2
votes
1answer
72 views
How to config Microsoft Office Application (Word / Excel) to stop adding personal information to the document?
I have created word document (*.doc or .docx) or excel documents (.xls or *.xlsx).
Sometime, these documents need to be sent to some customer and therefore require personal information to be removed ...
1
vote
1answer
55 views
Using ISBLANK with SUMIF formula
I am doing a summary table which references another page with VLOOKUP formula responses.
Currently using =SUM('CURRENT'!$J:$J) to calculate the total numerical values in column J, however there are ...
0
votes
1answer
60 views
remove values less than a number in excel array
I have a value that needs to calculate stock based on the previous years sales:
{=CEILING(SUM(IF('Inventory Transactions'!$H$2:$H$7137=LEFT($B6,3),IF('Inventory Transactions'!$O$2:$O$7137='Do Not ...
0
votes
1answer
54 views
Print multiple copies of “Print Selection” Excel 2007
I have a user who is trying to print only a certain set of cells in Excel 2007, but she needs to print 2 copies of the selection.
Using the print dialog, she selects Selection under Print What and ...
2
votes
1answer
57 views
Referenced values in a pivot table
I have a workbook that is being used by management to review data.
One sheet has a pivot table with some quite specific information.
The pivot table has multiple fields being pivoted in the rows. ...
0
votes
3answers
73 views
Excel “IF” formula error
I would like to create a formula in my MS-Excel Sheet. The Logic is given below:
The value of "A10" (cell) will be.....
equal to "A4", if A4>=A9 or
equal to "A5", if A6>=A9 & A9>A4 or
equal ...
0
votes
2answers
33 views
excel wrong date calculating
I have this weird excel problem where excel won't calculate dates correctly.
I had these dates in a column A:
10/12/2012
11/12/2012
12/12/2012
13/12/2012
14/12/2012
and so on.
In column B I wanted ...
2
votes
1answer
56 views
1/3 octave band chart in Excel?
I want to create a 1/3 octave band chart in Excel 2007 but I can't find the way to do it. Excel only allows me to put the 'x' axis into a logarithmic one, but the scale for 1/3 octave band is not this ...
0
votes
1answer
32 views
Column graph with multiple grouped values and one value above all of them as goal and with filled space between
I wish to create some kind of a special chart. I have 4 values, 3 are values measured over 3 years for state and the 4th is the goal where should it all go in future. The chart I want is a column ...
1
vote
2answers
116 views
Passing Range to ABS function in VBA
I would like to perform a function which looks like this
Selection.FormulaArray = "=GEOMEAN(ABS((C646:E646)))"
Since my range keeps varying I would like to pass the range as a variable which looks ...
1
vote
2answers
65 views
Semicolon separate column of values
I have a file with two columns: A and B. A is irrelevant to what I want to do here.
I am new to Excel. How do I bring together all the values in B with separation by semicolons?
For example, from:
...
-1
votes
1answer
58 views
Copy text from “joined cell” to another sheet's smaller joined cell
Normally, text appears in the cell when it contains a reference to another (=Sheet1!A1 will show the contents of sheet A1) However, if both target and destination are joined cells, and the target is ...
2
votes
1answer
68 views
Alt + E, S suddenly not working
Yesterday 'Paste Special' using the right mouse click and the keyboard shortcut Alt +E,S stopped working.
Application.commandbars("cell").reset did reset the right click option, but using the ...
0
votes
1answer
44 views
From date and time in column tot date in column and time in rows to be able to make a 2D chart
I have a lot of data in Excel in the following format:
column1 column2 column3
date hour variable
I want to make a two dimensional chart: time on the X-axis / date on the ...
0
votes
1answer
44 views
create a formula that will “dynamically” alter the sheet name from a validation box [duplicate]
I have a workbook containing monthly data sheets (sheet 1="January", sheet 2="February", etc.). I also have a "Data Display" sheet where I have endusers select the months summary they would like to ...
1
vote
2answers
104 views
How can hyperlinks be programmatically changed in Excel
I have a spreadsheet with 260 cells that contain different hyperlinks. Is there a way to programmatically change the link instead of editing each link?
The 260 hyperlinks are all unique and need to ...
2
votes
1answer
83 views
Excel “Remove Duplicates” feature does not remove all duplicates
When the Data Tools>Remove Duplicates command is used on the following list, some duplicates are not removed:
Key
46509
46509
51442
51442
73367
73367
80048
80048
88396
88396
102576
102576
108095
...
0
votes
2answers
67 views
vlookup values displayed month text
I am using a VLOOKUP to look at specifically a date column on a separate sheet.
=(VLOOKUP(A:A,'ECRM HISTORIES'!B:N,13,FALSE))
It displays the date as 25/05/12, however i need to display the only ...
1
vote
1answer
35 views
Concatenate with Spaces
I am using concatenate to merge a month and a serial #.
The end result though is something like Oct809900036.
I need the final view to be Oct 809900036 though, what is the best way to do this whilst ...
-2
votes
1answer
35 views
How do I get a day count that increases from the date entered to the date end in Excel 2007 [closed]
I need to track forms from the day they are entered to the day they are completed. They need to be completed in a specific time period or they are considered late. If they are late I also need to know ...
