The 2010 version of Microsoft's spreadsheet application.

**-1**

votes

**2**answers

54 views

### Automatically removing invalid or gramatically incorrect entries in Excel [closed]

I need to clear out all the incorrect data from my Excel sheet, such as grammatical mistakes and invalid entries, and I want to do it automatically.
I have tried the sort and filter option, but it ...

**0**

votes

**2**answers

38 views

### How to permanently color a column in Excel

How do you set a column or row to always be a certain color even when adding rows or columns? If you shade/color a column normally, when you add a row or copy paste another cell into that column it ...

**0**

votes

**1**answer

16 views

### Allow Excel user to select operator for formula

I'd like to setup a spreadsheet that would let the user select the operator to apply to other cells. For example: If A1 has 5 and A2 has 10, I'd like the user to be able to select the plus or minus ...

**0**

votes

**1**answer

25 views

### Conditional formating in Excel 2010 with multiple criteria including dates

I have two side by columns (C & D). In column C I have due dates, and in column D I have date completed. I'd like to conditionally format the dates in column C to change color as indicated by the ...

**0**

votes

**2**answers

19 views

### Microsoft Excel 2010: Copying multiple cell entries and placing them in a single column or row

30 42 50 78 99 119
47 50 81 120
47 56
57
60
61
62
62
64
67
I have data in ...

**0**

votes

**1**answer

39 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

**0**answers

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

**0**

votes

**0**answers

35 views

### Word Mail Merge - Filter Based on Partial Match of Text?

I'm using Word 2010 and Excel 2010 to do a mail merge.
In the spreadsheet, the Employer field has variations of the employer name, such as:
- SkyScraper
- SkySraper Inc.
- SkyScraper Mexico
In ...

**0**

votes

**1**answer

26 views

### Why can't Excel show me which data connections are disabled?

When opening a workbook with an external data connection, I get a yellow warning bar:
Security Warning | Data connections have been disabled | <Click Here to> Enable Content
I've found some ...

**0**

votes

**1**answer

25 views

### Merge data from three columns

I would like to merge the contents of three columns into a single column. I need to use a nested if formula as the columns take precedence over each other. Example column A1 may or may not have data. ...

**0**

votes

**0**answers

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

**0**

votes

**3**answers

23 views

### How do I display unique numbers in single cell? [closed]

I have a 5 digit number. For eg 23450 in one cell. I want to diplay missing number from this number. my other cell should display 16789 which are missing from 0 to 9 series. Below is example
Column ...

**0**

votes

**3**answers

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

**0**

votes

**3**answers

51 views

### Excel 2010 Specific cells for formula input cell arguements

Col A Col B Col C
Row 1 a a a
Row 2 a a a
Row 3 a a a
I am trying to set a specific range in the COUNTIF function, =COUNTIF(range,criteria).
Example 1: ...

**0**

votes

**2**answers

13 views

### extract substring from name in a cell in microsoft excel 2010

I am having following 2 row as example and name in one column I need to build 5 new column which are substring from name label column
i.e.number coming after rpb , cps, cm, bk & cd
how to do ...

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

**-3**

votes

**1**answer

29 views

### Software do not open xlsx file

The excel file saved under .xlsx do not want to open on another computer fitted with 2010 office version? The file keeps hanging and I cannot change the file format to .xls?

**0**

votes

**2**answers

27 views

### Subtract Two Cells. Result value

I want to subtract two numbers. The numbers are categorized, e.g. cell N2 (WAS) and N3 (IS). The cells populated are N1 thru N351. I want to calculate the difference between the two cells. If the N2 (...

**-2**

votes

**1**answer

35 views

### MS Excel 2010 Identify peaks in a data set, select its previous values and get a chart

I have a set of data about with approximatively 25500 cells, all contained in one column.
The data has a series of peaks that occurs, and I need to identify the 2nd peak (and the 4th, the 6th, and so ...

**0**

votes

**1**answer

21 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

**1**answer

31 views

### Copy distinct string by by matching items that meet a criterion

I need to copy a value when two criteria are met in two tables.
Table A contains name of District, name of municipality, and code of municipality.
Table B contains name of district, code of ...

**-1**

votes

**1**answer

24 views

### How to sum networkdays for multiple calendars for multiple people

I am using MS Excel 2010. What do I need to do to be able to create a table like this:
+----------------+--------+-----------------+
| Milestone Date | Team | Hours Remaining |
+----------------+---...

**1**

vote

**0**answers

13 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

31 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

20 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

105 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

38 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

63 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

28 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

29 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

42 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

19 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

32 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

28 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

63 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

80 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

36 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

29 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

38 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

17 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

18 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

41 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

17 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

31 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

26 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

19 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

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