**2**

votes

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**4**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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