**1**

vote

**1**answer

21 views

### Excel. Looking for exact match and return value

I have 3 Excel files. Excel file 1 and Excel file 2 contains:
Fixed data in column A
Different values in column H.
Excel file 3 (dashboard) contains the fixed data found in column A of the 2 ...

**1**

vote

**2**answers

2k views

### Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values.
I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...

**0**

votes

**1**answer

2k views

### d/m/yyyy to dd/mm/yyyy

I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy.
I want to standardize all the data of such column into dd/mm/yyyy , I format the ...

**0**

votes

**1**answer

3k views

### How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...

**0**

votes

**0**answers

10 views

### How do I split a worksheet into multiple files dependent on the column values, calculate sub-totals and plot graphs?

I have a large data set and would like to split these into separate files/worksheets and perform the same analysis over each data set.
I have found a macro to split the data into separate ...

**0**

votes

**1**answer

17 views

### Word got hidden in cells for long sentence?

When I write in cell of Excel 2007, and the sentence is long, it is hidden.
I want it to return to next line. Is it possible please ?
As you can see in this screenshot, the Hello world sentence is ...

**0**

votes

**1**answer

12 views

### Is it possible to sort a column by word in Excel 2007?

I would like to sort a colomn of my excel file following a "word".
I mean to sorting by word. Is it possible in Microsoft Office Excel 2007 ?
If I have :
AHG hELLO
BFF ...
FOO ...
AHG HI
DCE ...

**0**

votes

**1**answer

22 views

### VBA highlighting a cell if corresponding range in the same row is not blank

I am trying to enforce food name in column B of a file if column D to DX (Qty) has any value in it.
Rational is if any new request of food is received which doesnt appear in the file, the user can ...

**0**

votes

**3**answers

2k views

### Cells show formula, not formula result

We have an existing spreadsheet that has been working fine. Today we double-clicked a cell, to edit the formula, but did not change anything (we tested on other cells to check). When hitting enter, or ...

**0**

votes

**1**answer

3k views

### Show or hide rows in an excel sheet subject to the value of a particular cell (excel 2007 & Windows 7)

I have made a spreadsheet to specify decoration selections from a range of standard options.
There are five separate ranges so this is the first selection then within each range there are additional ...

**0**

votes

**2**answers

2k views

### Hyperlink to doc file slow opening

I've two excel file with inside some link to .doc and .pdf file. Both excel files and linked files are on a network shared folder. The first excel file is an .xls, the second an .xlsm.
While opening ...

**-1**

votes

**1**answer

24 views

### How do I isolate certain characters in cell content of an excel to new cell?

How do I isolate certain characters in cell content of an excel to new cell
Example: I have a big paragraph of information wrapped in a cell and I need to separate only few characters of that data ...

**2**

votes

**6**answers

23k views

### Why does Excel now give me already existing name range warning on Copy Sheet?

I've been working on a Microsoft Excel 2007 spreadsheet for several days. I'm working from a master template like sheet and copying it to a new sheet repeatedly. Up until today, this was happening ...

**2**

votes

**2**answers

411 views

### Use customized template from context menu

I wanted to use a customized Excel template for all new files. Sure, I can create a new template in the templates folder and in Excel use New and select my template or double-click on the template ...

**0**

votes

**1**answer

4k views

### How do I get Excel to pull data from multiple workbooks from exact dates based on an entered date

I am running windows-7 and using Excel 2007 Enterprise.
I am a truck driver and need to catalog my pay based on a changing day to day system. I am paid per mile, per stop, per hour, or per flat rate ...

**0**

votes

**1**answer

14 views

### Force external link in Excel to break if the file can't be found

I have an Excel spreadsheet that has an external link to another spreadsheet. What I want to happen is if
Main_Spreadsheet.xlsx
Secret_Data.xlsx
When someone opens Main_Spreadsheet.xlsx and they ...

**0**

votes

**3**answers

34 views

### Compare two sheets in Excel and extract the differences to other third sheet

My situation:
I got a huge excel sheet from a manufacturer of products for my online shop. This format:
product ID | price | name | ...
Every week the manufacturer is sending me a updated list ...

**0**

votes

**1**answer

15 views

### MS Excel cell references shifting after using a macro?

Basically this is what happens:
On Sheet1 I have a column of cells that are linked to other cells on sheet2. Looks something like this.
Sheet1!A1=Sheet2!A1
Sheet1!A2=Sheet2!A2
Sheet1!A3=Sheet2!A3 ...

**4**

votes

**6**answers

8k views

### Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what.
I have a spreadsheet, exported from our exchange server, that contains a column ...

**2**

votes

**4**answers

23k views

### Protecting the formatting in Excel 2007

I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've ...

**2**

votes

**1**answer

726 views

### vlookup in a cell that contains mid formula

I am trying to create a vlookup in a cell referencing a specific cell so that I can pull the data from my lookup table. Well this cell that I am referencing happens to have a mid formula in it, and ...

**0**

votes

**1**answer

40 views

### Why does excel tables break VLOOKUP formulas

I have a worksheet using raw data that Excel does not identify as Tables (ie. plainly putting values in adjacent cells), and on another part of my worksheet, formulas doing lookup in that data, like
...

**23**

votes

**8**answers

98k views

### Find Items in one column that are not in another column

I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A.
What's the quickest way to do this?

**0**

votes

**0**answers

50 views

### Display the content of Column A when I put a 'X' in Column B

I have a workbook that contains the projects that I'm working, in many tabs.
Each tab has one column that contains the name of the project and another that is an 'on going' column which I mark with a ...

**2**

votes

**6**answers

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

**3**

votes

**2**answers

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

**2**

votes

**2**answers

4k views

### How can I refresh a document I have open in Excel in read-only mode?

I have an Excel document that is stored on a SharePoint Server, which I always have open on my computer in read-only mode because I need to refer to it.
Every so often, in order to get the latest ...

**0**

votes

**1**answer

7k views

### Reference entire excel 2007 sheet to another sheet

I have one sheet with 100 rows of data.
I have a second sheet that will use the same data but with filters applied. In fact, I will have a dozen sheets, each with different filters.
My goal is to ...

**3**

votes

**1**answer

496 views

### Replace cell references with values without F9 using macro

This is an Excel macro question. Given a series of formulas such as the following:
= A1 + A2
= B2 + B2
etc., ...
I would like to replace each of these cell references with the values without ...

**5**

votes

**3**answers

8k views

### Excel formula for “select sum(B) where month(A)=3”

I have excel data as follows:
I want show the Total Cost for each month.
I can achieve this in Google Spreadsheets with the following formula:
=INDEX(QUERY(COSTS!$1:$1101,"select sum(B) where ...

**-1**

votes

**1**answer

879 views

### How to make this formula to work in Excel 2007?

How would one make this formula =MAX(LEN(A2:A9)) work in Excel 2007?
I want the value of the longest field in A2:A9 range.
I found this link: http://www.mrexcel.com/td0021.html, but it's old now.

**0**

votes

**1**answer

22 views

### How can I import a TAB delimited file with double quote text qualifier into Excel if a cell value already contains a double quote?

I am trying to import a TAB delimited file with the following format into Excel 2013
"Column A" "Column B"
"tjc0056421151r" "I\gs]hü"nsf^f\F*lqog\düûWp"
"tjc0058088269r" ...

**10**

votes

**2**answers

8k views

### Keyboard shortcut to switch between sheets in Excel

Does Excel 2007 have a keyboard shortcut that switchs between worksheets?

**0**

votes

**1**answer

23 views

### Excel 2007. I can't enable macro when I open document for second time

The document work perfectly on my computer with office 365, windows 7. But when I copy it to another computer with office 2007 and windows 7, it start normally ( I enable macro and it make everything ...

**2**

votes

**2**answers

21k views

### Finding X on Excel scatter plot/trend line

If I have some data in an scatter plot in Excel, e.g.
X Y
1 10
2 20
3 30
4 40
5 50
and I want to find the Y value for X = 10, or X=3.5, or whatever (obviously this is a simplified example) I've ...

**3**

votes

**2**answers

4k views

### Excel chart won't update, based on calculated cells

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing calculated values
The calculated values never change directly, but only as a result of ...

**0**

votes

**1**answer

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

**0**

votes

**2**answers

24 views

### Month by Month Pivot Table

I have a list of dates and data that go back a year. In Excel, I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly ...

**0**

votes

**2**answers

30 views

### Excel - Dynamic Cell Update using multiple criterias

I would like to know if there is a way in Excel to create a cell that will display a value using a formula that will calculate the latest entry by date and campaign.
If I have 3 columns DATE | ...

**0**

votes

**4**answers

2k views

### custom format for cells with nothing in them without using conditional formatting

if a cell is blank I would like to add text using a custom format. I've seen where text is added if a value is above or below a certain value. Can you add text to the cell if the cell is blank? I've ...

**0**

votes

**1**answer

42 views

### Is there a limit on the number of rows a sum function can calculate in Excel 2007?

I am trying to sum a column of 50938 values in Excel 2007 but keep receiving a "#VALUE!" error. The cells in the column do contain formulas. I also tried to sum the column after copying and pasting ...

**1**

vote

**1**answer

10k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

**1**

vote

**3**answers

6k views

### How to convert dd.mm.yyyy date format to yyyy-mm-dd in Excel 2007?

My customer entered date in dd.mm.yyyy format. As I want insert all the data in mysql database, I want the date in yyyy-mm-dd format.
I tried to format using Excel custom date format and built-in ...

**0**

votes

**1**answer

56 views

### Sheet name dynamically assigned from a cell value

Sub CreateWorkSheetByRange()
Dim WorkRng As Range
Dim Ws As Worksheet
Dim arr As Variant
Dim template As Worksheet
Dim xTitleId As String
On Error Resume Next
xTitleId = "Select Range"
Set WorkRng = ...

**0**

votes

**1**answer

24 views

### Microsoft Excel 2007

My gradebook spreadsheet has student assignment headings in columns B-H and their final grade average in column I. Student names are in Column A in descending order.
How can I print out Column ...

**2**

votes

**2**answers

11k views

### Excel workbook protection: how can I stop users tampering with a workbook?

I have a workbook with a lot of sheets, macro's and calculations going on. I now need to send this sheet out (not forseen before yesterday). How do I lock it down so that users:
are unable to ...

**0**

votes

**1**answer

18 views

### SUMPRODUCT where the product is computed from the row

I have a range AG6:AS38. It looks like this:
AG AH AI AJ AK AL AM AN AO AP AQ AR AS
--------------------------------------------------------
6 | 1 A B C D ...
7 ...

**0**

votes

**1**answer

2k views

### Refreshing Pivot Table clears Values and Column Labels fields

When I attempt to refresh an Excel Pivot table (by right click .. Refresh), all of the Column Labels & Values fields disappear, leaving only Row Label fields and an empty Pivot Table. How can I ...

**0**

votes

**1**answer

13k views

### Select Multiple Items from Excel Data Validation List

How can I set up the ability to chose more than one option for a data validation list and list them in one cell? So I have a validation list of A B C D. I want to chose A C D and have those three ...

**13**

votes

**2**answers

77k views

### Run an SQL Query With a Parameter from Excel 2007

I have a query in an excel table. I followed this to do it.
But how can I add a parameter from a cell into my query?
I am looking for a way to do this
select *
from dbo.Customers
where CustomerID ...