The 2010 version of Microsoft's spreadsheet application.

**1**

vote

**0**answers

14 views

### Plot a chart directly from a function in Microsoft Excel

I need an help with chart plotting in Excel (I'm using Excel 2016) let's say we have a simple function like:
y=1/x
Right now, to plot a chart based on this function I use two columns. In the left ...

**0**

votes

**2**answers

34 views

### Excel: Create conditional format when values different

I am trying to create a conditional formatting that would highlight in red when the value in the second column is the different as the first.
Example Table
ColumnA ColumnB
1 200
20 ...

**0**

votes

**2**answers

28 views

### Can I enter data into an Excel cell as a formula, but keep only the resulting value?

I have data to enter into cells that is the result of some basic addition. Rather than screwing up the addition in my head, I'd like to just type the addition into a cell, but without keeping the ...

**0**

votes

**3**answers

112 views

### How can can I combine two IF statement in Excel?

How can I combine two IF statement in Excel?
The first IF is checking a start date (in the MMDDYY format) from one cell (Staff!$G5) and if that date is greater than or equal to a date (in the ...

**0**

votes

**0**answers

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

**1**

vote

**1**answer

93 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) if ...

**0**

votes

**1**answer

31 views

### How to Sort a Pivot Table based on two columns of information

I work in the Auto Industry where I have to create a Pivot Table based on Auto information each month. The Sort Order of the Pivot Table needs to be
Model Series
Door
Cylinder
Model ID Code
Trim ...

**0**

votes

**0**answers

32 views

### Excel, worksheet scrollbar size

I have a problem with the vertical scrollbar on one of my worksheets. The worksheet contains ~20000 rows and the scrollbar is too big to use conveniently.
However when I click and drag it, it ...

**1**

vote

**1**answer

70 views

### Excel how to apply a filter to a column with one value in it?

tl;dr How can we force Excel to lock-in a filter for a Column which only has 1 unique value within it?
I am having a very hard time coming up with a nice "label" for this problem, so I believe it is ...

**0**

votes

**1**answer

21 views

### Calculate additional values based on results of Pivot Table

I am trying to make a summary of some cleaning results in Excel with the aid of a Pivot Table, but I am experiencing some troubles wrapping it all up. I have the following data:
Cleaning 1 ...

**1**

vote

**0**answers

31 views

### Show Excel Cell Only If Another Has Data

I am trying to format the below Excel sheet so that when a date is entered into cell J1, cells G24 - G37 populate with a date a specific to what I need. I currently have the cells formatted as follows:...

**1**

vote

**1**answer

35 views

### How to Link Cells in Column to Cell in Rows

I have an Excel database. I want to link Column cells to Row Cells. One by one doing this will take so much time. I want to use some formula. Please help. Apart from that I also want to link cells to ...

**-1**

votes

**1**answer

33 views

### Return a variable text string to an adjacent cell

I have a large spreadsheet.
Some of the cells contain order numbers in cells containing text.
The order number is located in various positions within the cell. I am trying to return the order ...

**1**

vote

**2**answers

95 views

### Sort Excel Pivot Table by Percentage of Count

I have source data showing timesheet approvals in the following format (for about 850 employees and 200 managers):
Employee Name Manager Name TS Approved?
Employee 1 Manager 1 No
...

**0**

votes

**0**answers

7 views

### Using check boxes to filter a contact list

I am trying to use check boxes to filter a contact list that is separated into divisions.
Basically what I would like to happen is that every division is named on the first sheet with a check box ...

**1**

vote

**1**answer

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

**-2**

votes

**2**answers

46 views

### How to combine several array arguments - SUMIF(S)? SUMPRODUCT?

I would appreciate input on this.
Date Value
7-Feb-2016 100
20-Feb-2016 200
15-Mar-2016 300
25-Mar-2016 400
My two criteria for a summation are
Date must be <= 31 ...

**0**

votes

**1**answer

31 views

### Aggregation of overlapping groupings in pivot table

I would like to aggregate a value of overlapping groups in a single pivot table.
An example of my data is:
Name, Value, Attribute 1, Attribute 2, Attribute 3
A, 1, True, True, True
B, 2, True, ...

**0**

votes

**1**answer

42 views

### Excel Arrays: average and if combining more than one criteria

I have a data for an assessment tool that has about 20 categories and about 200 items scored 0-3. The first half of the tool is mandatory, other sections are optional so there are a lot of blank areas....

**0**

votes

**0**answers

18 views

### Word/Excel document update within folder

I have a word doc that I've inserted graphs from various excel spreadsheets. The graphs in the word doc will auto update when they are updated in excel. My question is...How do I isolate the doc and ...

**0**

votes

**0**answers

33 views

### Excel 2010 Conditional Formatting issue

I'm experiencing a problem with conditional formatting in Excel 2010. I want any value other than 1 to be shown in red.
I am working with multiple tabs, with one main tab. The entries in the other ...

**0**

votes

**0**answers

29 views

### Anyone know what can make Excel freeze for a long time AFTER calculation?

When Excel calculates a large workbook (say, 60+ pages with 000s of formulae each) I figure it's pretty normal for calculation to take a while, especially when those calculations make fairly extensive ...

**0**

votes

**0**answers

54 views

### Copying only filtered data with a pivot table

I've got a pivot table with data from several geographical districts (60 columns 1000s rows). I have a pivot report I run by slicing on each district, using various slicers on other columns.
I want ...

**1**

vote

**1**answer

29 views

### Excel 2010: Hiding column with Ctrl+0 does not work

it is strange ... every shortcut overview I found so far claims that Ctrl+0 is meant to hide the selected column. On my computer (German Windows 7, German Windows 10, German keyboard layout) the ...

**1**

vote

**1**answer

36 views

### How to plot a complex table relation on excel?

How can I generate a table as displayed in the image attached using Microsoft excel. The x and y axis in yellow are simply perfect squares while The table content is composed of axis sums. I cannot ...

**1**

vote

**1**answer

33 views

### How to limit a filter to some rows only in Excel?

When adding a filter to an Excel spreadsheet, how do I limit its scope to some rows only?
For instance, in this document:
the “Hello” column filter will contain the values 0, 2, 4, 5, 7, 9 and 27. ...

**0**

votes

**1**answer

20 views

### Move data in a table present in 2000+ .docx files to a single .xlsx file (2010)

I receive 40+ emails per week each with a word doc attached. The word documents are in the same semantic format but carry unique client data authorizing services. I only need a portion of the data ...

**1**

vote

**0**answers

27 views

### Find and replace multiple values, according to table value - excel formula

I would like a FORMULA that change letters according to table of values that i make.
example:
êíöä = LOVE (because i made a table that show: ê=L, í=O, ö=V, ä=E).
example- Picture:
As you can see ...

**0**

votes

**2**answers

92 views

### Excel: What can cause manual calculation / F9 to stop recalculating?

What can cause manual calculation/F9 to stop recalculating some cells properly in Excel 2010 ?
I've Googled this problem and ruled out all the explanations I can find:
Calculation settings are ...

**0**

votes

**0**answers

12 views

### Search with key on multitple sheets

I need to count the presence of people for each week on a particular event.
Each sheet of my excel workbook has a date as a name, which is when the event took place.
The organisation of each sheet is ...

**0**

votes

**1**answer

118 views

### Excel Chart, Formatting Line with Stack Column Chart

I have a stacked column graph, it is duration based, goes for 16 hours, (starting at 4:00 pm on T, and ending at 8 am on T+1)
I have the primary axis completed, showing 0 to 20 hours, how can I get ...

**0**

votes

**1**answer

19 views

### Uncrowding a scatter plot when most points lie near lower end of X-axis

Given an Excel scatter plot thus:
where the bulk of the points lie at the lower end of the X-axis, how can the lower end be made to look less crowded (without removing data points), while ...

**0**

votes

**1**answer

25 views

### Combining/consolidating columns with almost identical data in Excel

Given the following table (which includes all the countries in the world, but is truncated here for convenience):
My ultimate aim is the scatter-plot the values in B against the values in E. The ...

**0**

votes

**1**answer

45 views

### Hightlight cells where the IFERROR=TRUE; Not “TRUE”. Suggestions?

Example:
Formula: IFERROR(H12,1)
Table:
I am trying to highlight every cell in the table that returns a 1 only if the IFERROR statement is TRUE (not "TRUE"), and without comparing the returned ...

**2**

votes

**2**answers

47 views

### Excel convert string equation to mathematical function

I have a spreadsheet whereas I have a string value in one column, and I have an amount value in another column, and a balance value in yet another column. I have a VLookup array to determine the ...

**0**

votes

**0**answers

50 views

### x axis formatting with dynamic excel chart

I'm having a problem with a dynamic x,y chart.
I set up named ranges using this method:
My x axis label is "time" =OFFSET(graf!$D$2,0,0,COUNTA(graf!$D$2:$D$1000)-1)
I do the same for my data (y ...

**0**

votes

**1**answer

59 views

### Excel Spreadsheet - Distributing Master Sheet rows and deleteing duplicates

I have a master sheet that I have the row distributing to different sheets with specific labels.
I want to have each row distribute to the appropriate tab (from the Master) dependent on the ...

**0**

votes

**2**answers

147 views

### Excel dynamic named range ignore blank formulas

In column A I have a formula that collates two other columns together.
=IF(ISBLANK(B5),"", B5&" "&C5)
Then in the Name Manager, a dynamic named range to use for a data validation drop down ...

**0**

votes

**2**answers

36 views

### How do I highlight some specific parts of a chart depending on the axis line?

I would like to know if it is possible to highlight (underline) some parts of a chart other than manually ?
See image below for a pivot chart where I underlined manually all the parts that interest ...

**0**

votes

**1**answer

11 views

### Correlating values between to columns

I'm a novice Excel user. Here's my problem. =COUNTIF('Roll-up'!$C:$C,B2) provides me with the total number of times value B2 (part number) appears in database C:C (corresponding list of part numbers)
...

**0**

votes

**1**answer

43 views

### Excel Pivot Table - How can I return a date in the row value?

I have raw data that includes hundreds of employees who have completed many different training courses and I am needing to insert a pivot table that shows the course name as the column labels, the ...

**0**

votes

**1**answer

26 views

### Can I use the output of a cell as the cell location in another formula?

Here's what I have:
Cell D13=AN and Cell AE13=13
Cell K13 has this formula =D13&AE13 so K13 outputs "AN13".
From there I would like to have a formula that grabs K13's output(AN13) as a cell ...

**0**

votes

**2**answers

47 views

### Excel VBA Run-time error 9 subscrit out of range

While closing the workbook I am getting:
Run-time error 9 subscript out of range
This is the VBA code:
Set wbk = Workbooks.Open(path & filename)
wbk.Sheets(sheetname).Range("b6").Resize(...

**-1**

votes

**1**answer

100 views

### Format Data in a Chart Data Table

I'm working on a project where I'm creating charts programmatically using VBA. These charts include data tables. The business requirements specify that the chart data cannot be tied to the source data,...

**0**

votes

**0**answers

15 views

### Merging spreadsheets with same columns, some data same, some dup and some needs merged [duplicate]

I have two very large identical spreadsheets. Both have data populated. They both have some data missing here and there, in many cases it's different elements, there is some duplication and needs ...

**0**

votes

**2**answers

28 views

### Excel 2010 - How to push values into many cells based on a single cell

I have what can be seen as a questionnaire with up to 60 questions (all yes / no). If someone answers Yes, for example, in cell B1 I know questions in cells B6, B9, B22, and B50 will be NO. To be ...

**2**

votes

**1**answer

29 views

### How would I select and group multiple images from excel worksheet?

I'm having an issue with Selection.ShapeRange.Group.Select, if it's removed I'm left with only the selection of all my images on the active worksheet. I would like to group the images on each ...

**0**

votes

**1**answer

127 views

### Excel - Sort by formula when there are duplicate values

My data will change, therefore I am using dynamic lists. Sorting needs to be dynamic as well. I do not want to click on the built in sort function.
I'm sorting dynamic data by formula, but it fails ...

**1**

vote

**1**answer

47 views

### Excel count unique values if second criteria is also satisfied

I currently have a formula to count all unique values of a range, however I would like to expand this count all unique values, if a second column meets a second requirement, for example.
A ...

**0**

votes

**1**answer

54 views

### Losing characters when copying and pasting into a batch file via VBA

I am currently using the following VBA code to copy and paste a range of data in an excel file to create a Batch file. I am running into the following problems:
Quotations are being placed around ...