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)

0
votes
0answers
19 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 ...
0
votes
1answer
19 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 ...
0
votes
1answer
22 views

Sheet name dynamically assigned from a cell value

I built a table in Sheet1!A1:A10: Mike Tim Sue Steve ︙ I would like Sheet2 to be named whatever I put in A1; so Sheet2 would be "Mike". But later I may want change A1 to a new name, e.g., ...
0
votes
1answer
16 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
0answers
10 views

Excel 2007 Automatic workbook calculation keeps going to manual

The excel 2007 that I have somehow not updating the formula cells, I go to Excel Option > Formulas > Workbook Calculation and the options keeps going to manual for some reason. I uninstalled Office ...
0
votes
0answers
11 views

Outlines of merged cells not staying consistent when a filter is applied

I have a spreadsheet that uses merged cells for visual clarity. The merged cells are in the B column (dates), and in the A column there are various values. I use filters in column A, and in my other ...
0
votes
0answers
8 views

Macro Hyperlink Error in Mac OS (Office for Mac 2011)

I am getting an error on a macro only when using a Mac. This macro was designed to solve a problem with a formula using the Hyperlink function to copy a link from another sheet for each row. (Excel ...
0
votes
1answer
21 views

Excel Month() function does not detect some date format

I have a simple table like this in excel: The formula i used was =IFERROR(IF(LEN(B3)>0,MONTH(B3),""),""). I check if a cell is blank by using LEN, if so ignore, else, convert it to month no. I ...
1
vote
1answer
22 views

How to use a variable once, across the equation, in Excel 2007?

okay, is there a way to declare a variable inside a cell, without calling the cell name 3 times, across the equation(?)? I came up with this, to calculate the age from a DOB entered using the ...
0
votes
1answer
13 views

How to delete creating automatic back up file for MS Excel?

Every time I use a file Excel it generate an automatic back up file. How can I disable this feature? I use MS Office 2007 with Windows 7
-1
votes
0answers
15 views

Add a cells content to another cell if cells at the top of the columns have only specific content

I already have a big part of this done thanks to another user, however I need it to go one step further please. I want to add the contents of cells in a specific row, based on a SUM formula. I want ...
1
vote
2answers
32 views

Average the numerical values where an identifier column meets a condition in Excel

In Excel 2007, I have a table with numbers in Columns F, G, H, I, and J. There is an identifier in Column B. I need the average of all numbers in Columns F, G, H, I, and J where the identifier in ...
1
vote
1answer
17 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
3
votes
1answer
35 views

Excel to count number of concurrent sessions based on start/end times

I have a massive set of data that I'm trying to work through. In Column A, I have a username, in Column B I have a session start date/time, in Column C I have the session end date/time. I am trying ...
-1
votes
0answers
14 views

Picking up data in excel with the date check

Let's say I have the following data: On the first row, there (mostly) will be dates in specific format. But sometimes there can be some texts as well. Now, I would like to get the average values ...
0
votes
2answers
57 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices ...
0
votes
1answer
8 views

Hyperlinking or linking in another way to a cell without it being able to change

How do I hyperlink or link to a cell from another cell in a way that when rows are added, and the row numbers keeps changing due to new rows of information being added throughout the sheet, the link ...
-2
votes
1answer
23 views

Add a cell content to another cell if a different cell has a specific content

How can I fill a cells value (e.g row 29 col A) with =sum(B1:Z1) but then only add the content of a cell in that row 29 if row 4 of that column says "UK IR". That way I can add all the cells together ...
0
votes
0answers
10 views

Auto copy formula in Excel 2007 to next sheet

I run an extremly Large Data qry every morning and dump it into a multi sheet excel file, in that file i have a Sheet set up for just formulas to copy from. Currently i manually copy these formulas ...
4
votes
1answer
155 views

How to automatically fill range by interpolating between lower and upper bounds

I apologize I do not have any code or examples too show for this. I am not sure how to even approach or identify the function or result I would like to achieve. What I have is spreadsheet with ...
2
votes
1answer
16 views

Validate that a combination of cells are unique in a row in Excel

I have an Excel sheet where 3 columns (A, B, and C) form a unique identifier for each row, but the values in the columns are not unique. For example: ABC REF 001 ABC REF 002 ABC ...
0
votes
1answer
33 views

Multiple Formulas in one Cell for hotel

I am trying to create a housekeeping spreadsheet where when a room number is entered into a cell a 0 or 1 (0 is for studio and 1 is for a 1 bedroom) is automatically populated in another cell. I have ...
0
votes
0answers
21 views

Query/Reports in Excel only

I'm trying to use Excel in a way probably more suited for Access. Unfortunately I have no access to Access or Visual Studio (outside the VB prompts in excel.) I have an excel "database" with several ...
0
votes
4answers
35 views

Excel 2007 How do I get rid of the 0 (zero) in this formula

I have dates in columns U,X,AA,AD,AG and AJ and Names in V,Y,AB,AE,AH and AK. I have the following formula to select the latest updates as they are updated. Columns U and V will be filled first and ...
0
votes
0answers
9 views

When moving data in Excel, how do I get data validation from destination

I have a workbook with three sheets, Active, Finished, and Tables. Tables contains auxiliary Tables for data validation. At some point a row in Active will be moved to the Finished sheet. Both those ...
0
votes
1answer
28 views

How to put Tables inside a “Master Table”?

I've been getting a beating by Excel recently! :) I want to make a "Master Table" that comprehends all of the other tables in my workbook. The problem I'm facing is that if I just refer to the cells, ...
0
votes
2answers
26 views

How do I create an excel formula to pick out differences in 2 cell values?

I have a column of company names (column A), a column of the 2014 revenue (column B) and a row of the 2015 revenue (column C). I want to somehow pick out which companies had zero revenue in 2014 and ...
0
votes
1answer
66 views

How to use Index and Match formulas for multiple criteria

I have a spreadsheet that contains Olympic information, with the following fields in columns: A) Athlete, B) Age, C) Country, D) Year, E) Closing Ceremony Date, F) Sport G) Gold Medals. I want ...
2
votes
1answer
23 views

Horizontal array constant definition issue

I can't understand where I fail (except following MS-original help :-D) in attempt to enter horizontal array constant (C+S+E seq) per MS guidance accessible either from Excel 2007 or 2010 help, or at ...
0
votes
1answer
33 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
2
votes
1answer
28 views

Excel: Clone a list for each unique value in a different list

I have two tables table1: list of unique Ids (list size is 3) and table2: list of items (list size is 3). How could I create a third list where for each row in table 1 it adds all the rows from ...
0
votes
0answers
46 views

Excel: Create a Collapsible Master-Detail View From Another Sheet?

I'm designing an excel template for importing data (into another DBMS). The problem is, the data will be separated (normalized) into several tables in my DBMS (master-detail model). Let's say I have ...
-1
votes
1answer
41 views

Can I split a spreadsheet into multiple files based on a Row in Excel 2013?

I have a spreadsheet in excel 2013 which have multiple column and rows. I need to send some columns to different people separate files. Please anyone can help me in this. Please try to use macros, or ...
-1
votes
2answers
56 views

If one number then a different number

I have two columns of numbers on a data page, over 500 pairs. And I need a formula for the working page that will insert the second number in “column B” if the first number is in “column A”. So if my ...
0
votes
1answer
19 views

How to avoid apply to range in copying conditional formatting in excel 2007 [closed]

I want to change the selected cell(A1) colour if its value is greater than other cell(B1) in same row.When i copy this conditional formatting to other multiple cells(A2,A3,A4...) in below rows, it is ...
0
votes
3answers
45 views

How do I import data from 6 Excel Workbooks into one on a daily basis?

I'm needing to be able to pull data from 6 individual Excel Workbooks that are all formatted the same, first line being the same header across all six and then the data starting row 2 going down being ...
1
vote
2answers
56 views

Excel: Sum a column of text excluding duplicates in another column of numbers

I am trying to figure out a formula. I need to know how many times a certain issue happens based on case numbers. Meaning there are multiple entries under a specific case number for that subject, but ...
0
votes
0answers
21 views

How do I copy/referrence last value of the column from another file and worksheet

I have two spreadsheets - one is the inventory sheet that gets updated with sales and purchases, and the other spreadsheet is where I want to reference or copy the ending inventory as soon as it gets ...
1
vote
0answers
35 views

Excel 2007 =Hyperlink issue. Calling an EXE with a / switch. The “/” turns into a “\”

I'm trying to run a program from a spreadsheet using the =HYPERLINK function. The formula looks like this (I'm using DIR just as an example so people can recreate the issue if they want): ...
0
votes
0answers
16 views

Excel 2007 document form button not working

I have a file which works fine on one user account, but not on other. Both users are logging into the same PC. What happens is that when the file is open and we click on the form button, it should ...
0
votes
0answers
14 views

Find a match of data in 4 columns within another array of 4 columns [duplicate]

Assume I have one row of data in 4 columns such as A1, B1, C1 and D1. Assume I have an array of data going from E1 to I20. I want to be able to find a row in the array such that the first 4 columns E, ...
0
votes
0answers
46 views

excel - how to count number of names in a column, name is specified in a cell

I have two worksheets, "Clients 2014" and "Receipts 2014". The receipts have client names for each row (each row is a receipt). The search key is in the "Clients 2014" worksheet. I want to ...
0
votes
1answer
41 views

Trying to highlight unique values across multiple sheets in Excel 2007

I am trying to compare the values from column A of Sheet1 (which I have renamed "AR") and column A of Sheet2 (which I have renamed "Paste Here") and highlight rows containing values that do not exist ...
0
votes
1answer
15 views

Apply conditional formatting to one cell based on part of a text in a cell

I have a spreadsheet containing a bank statement. In C I have a description of what the transaction is for sometimes just a word and other a sentence. In D I have money coming into the account and E I ...
1
vote
1answer
42 views

Excel 2007 how to put a text message in a cell if multiple cells are filled with data

I am trying to put a text message in a cell (say c1) if multiple cells in column A have data in. The cells in column A are A1-3, A5, A6 A8 and will have data from 1-5. I only want the text message ...
0
votes
2answers
32 views

Excel 2007 - formula to display last updated cells

I have 6 cells, A1-A6 in Sheet1. A1,A3,& A5 contain numbers 1-3 A2,A4,& A6 contain the date the numbers changed. A1 & A2 will be filled first. I want to display both cells in Sheet2 in ...
0
votes
1answer
27 views

Open a worksheet sheet in a different workbook by clicking on a cell

Is there an Excel feature to open a worksheet in a different workbook? For example, say I have a workbook called invoice.xlsx and another workbook called service.xlsx. In the invoice workbook, there's ...
0
votes
2answers
64 views

Count values for a specified month

Column A has date values (dd/mm/yyyy) and column B contains OK for some dates and is blank for others: A B 1 01/12/2015 Ok 2 01/12/2015 Ok 3 01/11/2015 4 01/12/2015 Ok 5 ...
0
votes
1answer
33 views

Matching and returning values to populate column

I have a workbook (Excel 2007) with two sheets. Sheet1 has more than 8,000 employees and their associated unit numbers, which is a 6-digit ID. I am trying to populate Sheet1!C:C with a corresponding ...
0
votes
0answers
18 views

Tex-style keyboard shortcuts for inserting symbols to MS Excel and Word documents

I've used Latex before in Linux and I loved it. My favourite thing about it was the reliance on the keyboard. For example, if I wanted to insert a 'sigma' symbol, I would simply type '\sigma' and when ...