**0**

votes

**1**answer

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

**16**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**5**answers

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

**1**answer

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

**3**answers

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

**4**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**4**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**3**answers

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

**0**answers

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

**16**answers

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

**7**answers

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

**1**answer

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

**2**answers

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

**11**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**0**answers

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

**7**answers

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

**1**answer

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

**0**answers

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

**5**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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