Microsoft Office Excel is a spreadsheet application written and distributed by Microsoft. Use this tag for problems specific to Excel 2007 for Windows.

learn more… | top users | synonyms (1)

2
votes
1answer
2k views

A sensible way combine two stacked bar charts in Excel?

I have one chart that has several stacked bars with identical components - one for each category. Each of the components of those bars can also be represented with a stacked bar chart, like the ...
0
votes
0answers
66 views

Using variables to conditionally format Pivot Table in Excel 2007

I have data in a Pivot Table which I need to conditionally format. How can you do this using one column as a variant to determine the colour of the corresponding cell (e.g. Region and then Month, then ...
-2
votes
1answer
2k views

Match up 2 columns in excel from one worksheet to another worksheet

I'm having trouble comparing two worksheets. I have worksheet A and worksheet B. In each worksheet, column A have the customer number and column B have the date. The same client and same date can ...
0
votes
0answers
36 views

Arrange date in a table using Excel 2007

I have this data from my work: Patient number test date comment 1 Echo 01-Dec-07 1 1 Echo 03-Mar-08 2 1 Echo ...
0
votes
1answer
269 views

locking cell of dynamic sheet based on value range

I want to use the Excel sheet for Dynamic purpose. Various product numbers that come from scanning barcodes need to be entered in column A. I want to ensure that if the product number entered ...
4
votes
1answer
49 views

2007 Worksheet Opens with Errors in 2010

I am trying to help a customer with a specific problem that they are having with deploying an Excel 2007 Worksheet to users if they are running Excel 2010. The spreadsheet in question has 5 to 6 ...
0
votes
1answer
292 views

How do I avoid #value in my excel sum equation?

When summing for the cells with nothing in them, I get #value using this formula =CB85+CC85 Yet I don't get it when I use this equation: =SUM(CI157:CJ157) But on using =SUM(CI157:CJ157) I get a ...
0
votes
0answers
52 views

Saving excel as csv without messing the formula

i have an excel workbook with 55 sheets. I would like to save the sheets as csv files (file name is the name of the excel sheet). When i run the macro, the files are created as desired but the macro ...
0
votes
0answers
79 views

excel pivot table structure in 2007/2010

In Excel 2010 my pivot tables have the following structure: Report filter (All) (blank line) Row Labels Average Value (data) In 2007, the same file looks like Report filter (All) ...
0
votes
0answers
232 views

Super slow Excel, how can I increase the performance?

I have an excel file which is super slow, like copying a cell to another takes more than a minute which should be done in a second ...When I try to copy 10 cells to another area, excel stops ...
4
votes
1answer
183 views

How to change default size of the comment boxes

It's incredibly frustrating to resize the box every time I put a comment. Anybody know the shortcut, or can provide a clue so I can script this?
0
votes
1answer
690 views

Counting and comparing rows for same values in excel 2007

I want to compare two columns of different sizes and count the number of rows in the two columns that are a match and report this in a separate cell. I have one column that is a list with the day of ...
1
vote
1answer
55 views

Split text seperated by multiple characters using excel 2007

I have a list in excel 2007 with text separated by 3 full stops. ( i.e ASDA...TESCO...MORRISONS...CO-OP...) Using the text to column tool I am unable to split using multiple characters (i.e ,,, or ...
1
vote
1answer
306 views

excel macro with column criteria to copy two rows in one sheet to another

I need a macro that searches for a string in a column; on finding that string it copies the row in which that string is found as well as the row above that. For example: Search for "boy" in column ...
1
vote
1answer
124 views

Adding a condition to a SUM formula results in #N/A error

I am trying to sum a range based on a few conditions. When I enter ...
0
votes
1answer
170 views

Single cell with structured table references with Excel 2007

I need to find the Excel 2007 syntax, for getting the cell (eg. 2nd row, 3rd column), in table reference flavor. To be clear, ref to the Microsoft - Using structured references with Excel tables ...
0
votes
0answers
401 views

Using VBA how can I reassemble Excel worksheets in different workbooks while maintaing the format?

I am struggling to complete this code successfully. Basically I have a master workbook which has defined range names. The first range is the header followed by a number of ranges (section1, section2. ...
4
votes
0answers
52 views

Excel 2007 doesn't preserve asian characters when converting to csv [duplicate]

I am trying to save a spreadsheet as a CSV file. The file consists of korean characters, and the resulting csv has those characters literally converted to question marks (0x3F). I am running on an ...
0
votes
0answers
112 views

Excel4Mac - can't find my VBA modules?

I have an Excel sheet with several macros, coded on a Windows machine. I used to keep the file in a dropbox folder for easy sharing with my home computer, which is a mac. I never had any problem ...
-4
votes
1answer
58 views

Want calculate the result depend on the output of the value of the same calculation

"=IF(AND(L2>0,L2<=3500),C2*50,IF(AND(L2>3500,L2<=25000),C2*35,IF(AND(L2>25000,L2<=40000),C2*25,IF(AND(L2>40000,L2<=50000),C2*21,C2*18))))" I am getting 0, but I understand that it will ...
0
votes
2answers
150 views

Excel: Use of spaces in filenames/sheetnames with INDIRECT()

Formula is: =INDIRECT("'Z:\ADMIN PROJECTS\[FORWARD ORDERS.xlsx]"&A1&"'!C$2") Value of A1 is SEPT 13 in text (to be replaced by another formula soon). Excel keeps giving me #REF. I'm pretty ...
1
vote
1answer
90 views

How can I use excel to create a multiple IF function?

I have a spreadsheet comparing numbers of programmes sold by my company. I want to create a formula that will total several variables. In one column I have the month then whether it is a "Finance" ...
0
votes
4answers
1k views

How to stop Excel from formating the 16 digit account number in a way to avoid making the last digit zero?

I have large number of bank account numbers of different banks. Some banks account number start with zero and some have 16 digits. When I paste the data in Excel the leading zeros will be removed and ...
0
votes
1answer
2k views

Excel Multiple Cells Included in an IF Formula

I am trying to compare 6 cells, and get a pass or fail at the end, but in Excel it looks like it will only let me have 5 cells. I'm not sure how to word it. like for example: Pseudocode: if (A1 and ...
1
vote
1answer
24 views

Adding table values between an undefined list of worksheets that keep data key associations

Let's imagine you have a totals worksheet and 5 other worksheets that consist of the data for the totals worksheet. Lets also say every worksheet has the same table structure defined on it. For ...
0
votes
1answer
91 views

sumif with date criteria in another worksheet

I want to SUMIF in another worksheet values having a specific date as criteria. Like : =SUMIF('Data Form'!G:G,"'Data Form'!1/1/2010",'Data Form'!N:N) I want a specific value in a cell (i.e ...
1
vote
0answers
98 views

How to disable PASTE in Excel without VBA

This is an old question - You can't really force validation rules in excel b/c even if you protect your sheet a simple copy/paste can bypass all validation (very strange implementation of protection ...
0
votes
1answer
64 views

How to convert 58m32s to 00:58:32 or 72m10s to 01:12:10

I have a excel column with data like: 58m32s 72m10s 125m02s And would like to show it like: 00:58:32 01:12:10 02:05:02 What formula combination should i use to make this possible? This should(?) ...
0
votes
1answer
55 views

Mail merge multiple rows

My table in excel : Joe Smith, 11-1-12, 9-10am Joe Smith, 11-1-12, 11-12pm Joe Smith, 11-2-12, 7-8am Sara Roy, 11-1-12, 9-10am Sara Roy, 11-1-12, 11-12pm Needed result which should go in mail to ...
0
votes
1answer
37 views

Two formula in the same cell

I have a 'daily hire' item in F5 at $10. When it's on hire (H5=1) it needs to be paid at 100% (i.e. $10) not on hire (H5=0) it must be discounted by 25% What is the formula for this? When I place ...
0
votes
1answer
2k views

match the name of a worksheet tab with a specific cell value automatically in Excel

how can I match the name of a worksheet tab with a specific cell value automatically. In other words, If I change the value of that cell, the name of worksheet tab would change automatically to that ...
0
votes
1answer
90 views

Calculate difference between two times on different dates in Excel

I have 4 cells: cell A1 contains 16/8/2013 (this is date of entrance) cell A2 contains 15:30 (this is time of entrance) cell A3 contains 19/8/2013 (this is date of leave) cell A4 contains 10:00 ...
0
votes
1answer
82 views

In Microsoft-Excel 2007 How do if find a subset of numbers that add to a given total? [duplicate]

How do I find a subset of numbers that add to a given total? For example: i have a column of numbers indicating payments received. I need to match these various numbers to a total deposit amount.
0
votes
0answers
57 views

Excel/Word 2007 inserting different images in mail merge

How do I setup excel 2007 so I can do a mail merge in Word 2007? I am fine with all of the merge, but how do I do it to include a different image on each page. Basically I am doing a front cover with ...
1
vote
0answers
141 views

Microsoft Excel Copy one row to another worksheet if cell contains specific data

I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". ...
0
votes
1answer
33 views

Hyperlink a text file in excel

I have n excel file with a hyperlink of the text file. I want to know is there any way in excel to see the text of the file instead of hyperlink?
0
votes
1answer
605 views

How to print two different sheets with different scale options using Excel 2007 and Excel 2010?

I have two sheets in a .xlsx file. The first sheet uses columns A to C and fits into a single landscape orientation A4 size paper. The second sheet will fit into a single landscape orientation A4 ...
0
votes
1answer
682 views

Copying columns in Excel from sheet1 to sheet2 without having to cut and paste

How do you copy "sheet1, column a" onto "sheet2" without using cut and paste? I have tried using a basic =sheet1!A1 formula, and this almost works; however, I have to add and remove data from ...
0
votes
2answers
114 views

How do I count different values/characters in a column of cells?

I'm not sure if my description above is accurate. I have a client's full name and address in a single cell e.g.; Mr Smith, 1 High Street, London NW12 1AB I have hundreds of names, address and ...
0
votes
0answers
171 views

Vlookup multiple columns/rows and return to a single cell separated by commas

I would like to vlookup multiple rows/columns and return to a single cell separated by commas. For example: Date Customer Code Product Price 25/07/2013 112136 Cement OPC ...
0
votes
1answer
179 views

Excel opens a file to the wrong sheet within the workbook

When I work on a worksheet, and when I stop I leave the 3rd page open, I had saved my document and had closed my workbook and while closing i had kept it on 3rd sheet itself. When opening, I need the ...
1
vote
3answers
1k views

Using MAX() in Excel against a list of dates using multiple criteria

I've searched and searched and trialled every answer but none seem to work in my situation. Using Excel 2003. I have a table with the columns [DATE], [SITE], [INCIDENT]. I'll explain in something ...
1
vote
0answers
64 views

excel: how to filter for a specific ID given time constraints on a text field

I have an excel sheet that has a three fields: USER_ID | DATE_CREATED | TAGS Tags applied to the items in the sheet vary quite a bit, and are set up like |tag1 tag2 tag3...| within the field. I ...
0
votes
2answers
230 views

Excel sheet becomes very slow

I am working on an Excel 2007 workbook (less than 1gb in size). There is one sheet which has formulae linked to other two sheets in the same workbook. The problem is that it becomes really slow ...
0
votes
0answers
306 views

Create a Macro that searches, copies and Exports from two workbooks and imports into 1 master workbook

I am new to creating macros. I have tried searching for existing macros to help with my current request; however I have not found a helpful one. Please let me know if you can assist. Contents ...
0
votes
1answer
244 views

Scatterplot with variable X on X axis and Y on Y axis

I have a dataset with variable A (Age) and B (performance). I want to create a scatterplot with variable A on the X axis and B on the Y axis, but Excel is acting all weird with it. I have approx 120 ...
2
votes
1answer
406 views

How to sort a column by occurrence count in Excel?

Let's say I have a column like this: Dog Bird Cat Dog Dog Dog Bird Cat Bird It has 4 Dog, 3 Bird and 2 Cat I want to sort this column descending by these count numbers. I mean result should be ...
3
votes
2answers
358 views

How to save duplicate images in Excel to different JPEGs

I have an Excel sheet with images which are stored as objects in one column and product names in another. I was trying to extract all the images to JPEG files. I was able to achieve this by saving the ...
1
vote
1answer
589 views

PivotTable — how to sum the result of a countif formula by group?

Current Setup A table (Table1) that has the following fields: Organization Name Person Name Several fields that users can put an "X" into (each represents a "module" that users would need access ...
0
votes
1answer
3k views

Excel: filter a column by more than two values

I have a worksheet with a column, user_ID, that contains a large number of user IDs I'd like to filter it down to about a dozen IDs, but using Filter -> Custom Filter only allows me to filter by 2 ...