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
1answer
41 views

Excel: How to Group Dates Per Week in Line Graph

I have data that looks like this: Actual End Date ----CP 2016-04-22------------4 2016-04-26------------3 2016-04-26------------9 2016-04-22------------7 2016-04-26------------6 ...
16
votes
16answers
142k views

How to get the current column name in Excel?

What is the function to get the current line number and the current column name for a cell in Excel?
0
votes
1answer
11 views

Sort data on repeat sequence

I want to order the data of my spread sheet on a repeat sequence Actual a a a b b b c c c Desired a b c a b c a b c Any suggestions are much appreciated
0
votes
1answer
15 views

Reference formula 'Text' within another cell in Excel

I would like to insert text from a cell into a formula. For example, using the formula: =LOOKUP(A1,'Sheet2'!B2:B10, 'Sheet2'!D2:D10) I would like to change 'Sheet2' to some other reference (i.e. ...
0
votes
1answer
28 views

Remove words in a cell that are already in another cell

I have Business names in column A and descriptions in Column B. this descriptions included business names also. Example: Column A: McLain Homes Column B: McLain Homes Est in 1990 McLain ideally ...
2
votes
5answers
29k 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 ...
0
votes
1answer
5k views

How to calculate Bradford Factors with Excel 2007?

Bradford Factors are used by some to measure the significance of absenteeism and are computed for each individual as: S squared times D, where S is the number of spells (continuous periods of absence) ...
2
votes
3answers
171k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
6
votes
4answers
89k views

How to combine values from multiple rows into a single row in Excel?

I have a data dump in Excel that consists of annual customer data for two different values. The data was provided with a separate row for value for every year and customer. I.e. it looks like this: ...
-4
votes
0answers
22 views

How do I filter dates? [on hold]

Can I see date only by month or maybe even weeks to see not the whole table, I know how to do that with filter is there any other way? DEZINFECTION DATE PLACE 11.11.2015 BETI 15.11.2015 ...
0
votes
1answer
17 views

Count specific assets (one column) which belongs to unique users (depending on another column)

To get the total of In Stock. I used this formula and it works. but this formula works for specific text. =SUMPRODUCT((A2:A6="In Stock")*(B2:B6="Laptop")) I need simpler formula to count rest ...
0
votes
1answer
5k 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 ...
-1
votes
0answers
26 views

Java Installer crashing when accessing VBA code

I work usually with DDE Excel. I have two computers, one with Windows XP and another with Windows 10 64 Bit. The problem happens with the latter computer. I connect the computer with provider DDE ...
0
votes
1answer
5k 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
1answer
34 views

Spreadsheet formula for adding all values adjecent to multiple instances of text cells

Given a table with unique and duplicate text values in a column with number values adjacent in the following format: A|12 B|23 C|98 A|66 D|86 E|3 B|25 A|65 . . . The values are simplified for the ...
0
votes
4answers
5k views

Excel 2007 time miliseconds operations

I am using Excel 2007 and I am trying to subtract these two values: 11:27:55.428 11:28:09.813 I have tried to format both as time and as "hh:mm:ss.000" and every time I try to subtract them I get ...
0
votes
0answers
16 views

How to insert online pictures into excel with VBA

I want to add images from my web image repository so I have all the hyperlinks in row 3 (C3:L3) and in row 2 (C2:L2), I would like to automatically insert the image whenever I press the Display image ...
3
votes
0answers
51 views

Checkbox location changes when workbook is opened in Excel 2010

I am using Excel 2007 at home to develop a sheet for work that has data input using multiple checkboxes. Each checkbox is in an empty cell. When I open it at work with Excel 2010, all the ...
-2
votes
0answers
14 views

excel formula - suming multiple columns of one row in an index

i want to sum 10 columns of data. I do not want to just sum based on the cell reference. I want to sell based on name ranges. However, I don't want to type all 10 named ranges into the sum box. I ...
1
vote
1answer
22 views

Pie Chart in Excel, is it possible to have a slice for a remaining balance?

There is a budget for each employee to use on expenses. We keep track of expenses throughout the year as it gets used. At the end of the year, a lot of these budgeted dollars do not get spent and i'd ...
0
votes
0answers
17 views

Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data: 1st column is the name of the Route 2nd column is Time1 in decimal hours 3rd column is Time2 in decimal hours 4th column is TimeDifference in decimal hours (or decimal ...
4
votes
2answers
4k views

Excel Conditional Formatting Multiple Data Bars and Data Icons in one cell

I am using Excel 2007 on a Windows machine. I am attempting to place one data bar and one data icon into a cell under the conditional formatting. The issue is that I don't really want to have data ...
2
votes
1answer
4k views

Pivot table on filtered data

Is there a way to run a pivot table on an Excel sheet that already has columns filtered? Thus far, I've had to manually copy and paste the sheet into another sheet and then run a filter on that. Is ...
0
votes
3answers
30 views

Leaving a cell blank in excel, or display a different cell

I've tried to read the other posts and follow but I just can't wrap my head around this formula. I would like F9 to: be blank if no data is entered in D9 if data is entered in E9, then D9*E9 if ...
12
votes
3answers
77k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format ...
0
votes
0answers
31 views

Excel converts comma delimited to tab delimited when saving [duplicate]

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
15
votes
16answers
87k views

Copy Excel worksheet and maintain relative cell reference in formulas

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula =B!23 becomes ...
4
votes
7answers
58k 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
1answer
19 views

Values need to copy from Col A to Col B in Excel without data loss

In my Excel, I have 2 columns For Ex: Col A & Col B. In Col A I have 100 Records but in Col B having only 50 records that is scattered not in sequence. I have to copy and paste the same ...
0
votes
2answers
3k views

How to get count in pivot table that does NOT count duplicate entries

I am setting up a pivot table, and I would like for it to give me the count of the number of unique combinations of two fields, not just the total count. That is, each combination should only be ...
12
votes
11answers
82k 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 ...
0
votes
2answers
16k views

Have Pivot Chart show only some columns in pivot table

I have a data table. In the table I have some dollar amounts. I also have formulas that use lookups to group these dollar amounts into groups in the data itself. I then have a pivot table where my ...
0
votes
1answer
9k 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 ...
4
votes
2answers
7k 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
0answers
16 views

Excel 2010, “Runtime Error '32809': Application-defined or object defined error”

I am having this error when I open up certain workbooks that contain macros. The files are stored on a network drive and this error only happens on a few computers which leads me to believe the ...
0
votes
1answer
48 views

Check excel cell if font is a certain color?

I want to use vba to check if the text in a cell in excel is of a certain color, lets say red. Any ideas?
1
vote
1answer
40 views

Excel IF formula using before or after date and amount

I need help writing a formula for the following. superuser sample I hope you can see my image, and I explain myself well enough. I want column L (my new column) to display column I(dollar amount) ...
0
votes
2answers
3k views

Lookup Multiple Results for Multiple Criteria

I've got a list of parent SKUs for items I need to create in my inventory system. This list has been finely paired down to the 165 products we would like to carry. However, each one of these 165 SKUs ...
0
votes
2answers
11 views

Looping through two column to check for condition

I want to loop through column P and see if there is a cell that has the number "1" in it then at the same time loop through column N to see if there is also a number "1" at same row/column, if there ...
-1
votes
0answers
21 views

How do I make this kind of line graph with MS excel or if not possible what is the next possible solution?

1I wanted to make this graph. The first figure is a single figure line graph with 4 vertically connected line graph . x axis is weeks and y axis is %. The other figure is an 8 line graphs connected ...
9
votes
7answers
57k views

How to turn hundreds of text URLs in Excel into clickable hyperlinks?

How do I turn a column of urls into hyperlinks, so that users can click on the url in a cell and have it open in a browser? I pasted 100 urls and each went into its own cell. When I double-click in ...
1
vote
1answer
3k views

VBA: How to replace entire Excel cell value basing on its content?

I have an Excel Spreadsheet with some names in a cells. There can be as one name per cell as multiple names in one cell. For example: Cell A5 contains "Joe", cell BD54 contains "Joe;Harry;Molly", ...
0
votes
0answers
26 views

Excel 2007: Why #REF!+#REF!=number in evaluating formulas?

Total A.xlsx contains formulas adding cells (without the help of functions, just the "+" sign) from several files named 01 A.xlsx, 02 A.xlsx and so on. All files (including the total) are in the same ...
3
votes
5answers
50k views

How to get excel row numbers to skip the header

This is really a cosmetic question. Excel by default starts counting from line one which is the header. Is there some way to have it start counting from the real line one (the line after the header). ...
0
votes
1answer
23 views

Excel: How to check values in mutiple rows which mark values per day and highlight row with the earliest entry

I have a database wich shows value assigned to each customer in each week of the year. What I want is to have highlighted (i.e. marked with X, at the very end of my report) the earliest week on which ...
1
vote
1answer
24 views

Why can Excel 2007 not calculate sub formulas right? [closed]

I have the simplest possible scenario: open a new Excel 2007 document In the first row put 6.99 In the second row put 4.99 In the third row put =A1*0.4 And in the fourth row =SUM((A2-A3)/A2) This ...
0
votes
1answer
32 views

Change name box of a image inserted into excel worksheet

When you insert a picture into a excel worksheet, you get automatically Picture 1, Picture 2, and so forth...... I have a function when a picture is selected to put black border around it. Problem is, ...
1
vote
1answer
60 views

What is the Excel Formula to calculate based on consumption and rate

I need help to come out with a solution for this: Actually I want to calculate my electricity consumption. as the attached pic. the first consumption 0-200kwh, rate $0.218, for 201-300 consumption ...
0
votes
1answer
5k 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
0answers
22 views

Excel 2007 Unprotect Sheet prompt in password protected sheets on Windows 7 machines

Windows 7 users of software I created in Excel get an "Unprotect Sheet" prompt when clicking on any sheet or cell in a sheet that is password protected. They hit cancel, sometimes several times and ...