The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

-1
votes
2answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
3answers
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
3answers
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
3answers
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
2answers
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
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 ...
-3
votes
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
2answers
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
2answers
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
3answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
0answers
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
1answer
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
2answers
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
1answer
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
1answer
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
0answers
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
0answers
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
0answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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 ...