The 2010 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

23 views

### Force PowerPoint to open a new Excel instance

When using the insert diagram function in PowerPoint, PowerPoint automatically opens a new Excel window. Unfortunately, if you already have an Excel workbook open, it will simply use the same Excel ...

**0**

votes

**0**answers

34 views

### Writing formula in excel 2010

I'm trying to make a sheet read all past bill data from a main rundown in order to do this i need to have one cell copy the date and keep it even after i change the original date then have the next ...

**1**

vote

**1**answer

33 views

### VBA Excel: Error during range selection during workbooks iteration

I have several files in one folder with the column "Part Number" but not all of them are in the same column number. The list doesn't necessarily start in the same row either.
So I first look for the ...

**1**

vote

**1**answer

52 views

### Excel 2010 VBA only affecting last row in range

I have some VBA code written in Excel 2010 to force padding around the rows in a table, but part of the code only affects the last row in the range. Here's the full code:
Private Sub ...

**0**

votes

**1**answer

28 views

### Turn a 2-column table into multiple columns based on row value

I have a 2-column table with rows as such:
1 Brand1
1 Brand2
2 Brand3
2 Brand4
2 Brand2
2 Brand5
3 Brand5
3 Brand2
4 Brand3
I would like to turn each value from the 1st column into a column header ...

**1**

vote

**1**answer

90 views

### How do I link to excel chart data in PowerPoint with relative paths?

This question is similar to the question posted in
How do I embed video in PowerPoint with relative paths?
But in my case I search for an answer to get Excel charts, which are linked in an absolute ...

**0**

votes

**1**answer

33 views

### Use INDEX and MATCH function to find value and get a corresponding value from the returned rowindex

I want to combine columns [country code] and [admin1 code] with a "." in between and then lookup that value in Sheet1 in the [admin1code] column.
When a match is found I want to get the corresponding ...

**0**

votes

**1**answer

25 views

### How to have excel paste a value in a specific cell according to another data table

I'm working with excel 2010,
I have an excel sheet with two tables. The primary table contains a calender and each calender day has a specific numeric value in the cell below the date.
The numeric ...

**0**

votes

**1**answer

27 views

### Formula to change entries based on duplicates

Basically I have a table of approximately 56000 records to be used as a source data for a pivot table.
There are duplicate values in the first column as well as unique values. My goal is, if a ...

**0**

votes

**2**answers

47 views

### Insert/Display Two-Page Word Object in Excel Sheet

I've trying to take a two-page Word doc and insert it into an Excel 2010 worksheet. I'm not trying to link to the original document.
So far I've been able to insert the object, but it only displays ...

**0**

votes

**2**answers

29 views

### Need to find a count of unique items in one column based on a value in another column

I need to find the unique count of items in a column based on a criteria or condition in another column.
Example
UserID Cred Type
...

**0**

votes

**0**answers

16 views

### Automatic regenerating of report on update excel document

I have one file in xls format in Excel program. Usually I upload this data to sql in some created table, and regenerate the report, then export it.
Sometimes it is updated through svn and I need to ...

**0**

votes

**2**answers

73 views

### Excel 2010 formula, How do I write this formula? (VBA)

I need a bit of help from the more experienced Excel VBA users.
Basically I have 2 groups of 3 cells (6 cells total)
If one group of 3 cells is filled in it needs to accept it and not return a ...

**1**

vote

**4**answers

39 views

### Filtering character in Excel

I have a column in excel file which is mix of set of character and numbers, I want to filter out all rows starting with character.
Example
Column1
abc
12345
def
5678
xyz
7895
tryc
I want to ...

**1**

vote

**2**answers

110 views

### How do you make a set of cascading dropdown lists in excel?

I'm working on a system to try to take inventory more quickly instead of filling in each row by hand.
The reference data is several hundred rows. The first 3 columns in the reference sheet are Class ...

**0**

votes

**0**answers

13 views

### How to merge multiple cell into single cell

I have same name in multiple cell instead of showing multiple cell. I need to show same name in single cell.For Example ![Multiple line][1]
For example
keyboard 223
keyboard 34
keyboard 23
...

**0**

votes

**1**answer

733 views

### Split Excel worksheet into multiple worksheets based on a column with VBA

Question is simple and may be repetitive.
I have an Excel workbook which contains around 50 columns
I have a criteria column for splitting this workbook into mulitple workbooks
The approach is as ...

**3**

votes

**2**answers

138 views

### How to change Excel chart size with screen size

I have posted the following question on StackOverflow, but was told that it would be more appropriate here instead. Any assistance that could be provided would be much appreciated.
I have a Excel ...

**0**

votes

**2**answers

39 views

### Excel If formula

I am trying to run a simple formula in Excel:
=IF(V3>419, "Pass", IF(V3>459, "Merit", IF(V3>499, "Dist", IF(V3>519, "Dist*","Fail"))))
I have 2 columns; Overall and Grade
Overall ...

**0**

votes

**2**answers

52 views

### How can I return a list of specific words found in a cell's contents?

I have two columns, one with a string of text (A1), the other blank (A2).
A1 looks something like this:
"Briefs on Southern Africa, Rhodesia, East of Suez (Including Soviet
Naval Expansion), ...

**0**

votes

**0**answers

53 views

### Reformat a text file using a macro in Excel

I need to reformat a report I receive every month as a text file so I can perform spend analysis on the data in Excel. The report was in a statement format before converted to a text file because the ...

**0**

votes

**1**answer

37 views

### Advanced filtering leaving on unique values and removing duplicates

On the spreadsheet there are two subsets of data that are separated by color based on where I pulled the information from. Within these subsets are duplicate entries.
I do not want to simply remove ...

**0**

votes

**0**answers

9 views

### Pointing to another excel worksheet in a 3d table dynamicaly

I have a 3d table for some stocks of products, all sheets identical and all.
If product name is "OIM", the worksheet the data is on is called "ROIM" and so on.
Now, I would like to find a dynamic ...

**0**

votes

**1**answer

76 views

### Excel - Script that search a sheet for a cell containing specific text, and replace the text with a specific value

I want to split a cell with data into other cells based on the data in the original cell. The data from the original cell looks like this (all content in a single cell):
...

**-1**

votes

**1**answer

87 views

### Invalid date value in csv file

I export data in csv format from sql server database. It contain 5 column. one column have date and time value. When i checked the date -time value i found date time value is in wrong format. I add ...

**0**

votes

**3**answers

43 views

### Check if first letter in cell is within provided range in Excel

I have a list of companies in column A. I'd like another column to check if the first letter of these companies falls within the range ...

**0**

votes

**0**answers

16 views

### SUMIF not working as expected

I've written a SUMIF array formula that isn't working correctly and was wondering if someone could help me out.
My formula is pulling data from a worksheet called "Encounters Report" that contains ...

**3**

votes

**2**answers

819 views

### Why is Excel 2010/2013 taking 10 seconds open any file?

I have a fast Windows 7 PC with two SSDs and 16GB of RAM, so I'm used to programs loading very fast. But recently, for no reason I can figure out, Excel has started taking way too long to open Excel ...

**1**

vote

**1**answer

31 views

### How can I force Excel to recalculate after a UDF macro error?

I created a bug in a user-defined function that is called from a large number of cells on many tables in an Excel workbook (not the way I would design it, I just "inherited" it).
But now, I can't ...

**0**

votes

**1**answer

36 views

### Combining SUMIF() and SUBTOTAL() for Dynamic Subtotal

I need help combining two formulas.
What I need is to subtotal a range based on a criteria and I need that subtotal to change when the range is filtered.
I have two formulas that work separately. ...

**0**

votes

**3**answers

73 views

### Formula =IF(VLOOKUP(…)=Cell;…) does not work [closed]

According to this and my own testing, using VLOOKUP can be compared to a specific value inside of IF.
E. g.: = IF(VLOOKUP(...) = 20, [then value], [else value]) works.
But if I compare the result ...

**0**

votes

**1**answer

24 views

### Pivot data in excel

I have an excel spreadsheet, where all values are in A column. However, they should be distributed so A1-A5 are in A column, A6-A10 in B column and so on.
Is there a way to automatically pivot data ...

**0**

votes

**0**answers

20 views

### “Customize Excel 2010 Highlight Track Changes” for specific cells (not whole worksheet)

customize excel 2010 highlight track changes
In regards to the above solved question, Can you provide insight on how to have changes highlighted for a specific range of cells, as opposed to the ...

**1**

vote

**0**answers

45 views

### Using getpivot in excel to create flexible reports based on user inputs

I am trying to make a report in Excel that sits on a very large set of data (set up in proper pivot form). I want to be able to select a value for a few fields (or select a value from 1 field but ...

**0**

votes

**0**answers

24 views

### incorrect IF formula evaluation

I have the following formula:
=IF(SELL_INVESTMENT="YES",1,2)
It returns not 1 or 2 but 0.
I verified that the cell contains YES and it should return 1.
The file contains over 1000 cells. "Trace ...

**1**

vote

**1**answer

55 views

### Excel pivot tables: reverse running total

Is it possible to create a reverse running total in an Excel 2010 pivot table?
Using the basic example below, I have a list of number of sales per month (B), along with a running total (C). Without ...

**0**

votes

**0**answers

23 views

### How to use Color Bar for String Values in Excel 2010

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this ...

**1**

vote

**1**answer

20 views

### Excel 2010 - Large Practitioner Database Consolidation

I have a database of 1800 employees (1 employee per row) and a binary confirmation of whether they have 1 or more of the 105 professional certifications we track (1 certification per column).
I ...

**1**

vote

**1**answer

52 views

### Conditionnal Formatting with Dynamic Custom Formatted Date

My problem is that I want to color in red a list Custom Formatted Dates when the date is overdue.
For instance, I got two actions:
Buy Bread : Must be finished before 27/01
Buy Milk : Must be ...

**0**

votes

**1**answer

35 views

### Changing the color of a shape every 5 seconds in excel using VBA

Hello I am looking for the VBA code to change the color of a shape in Excel using VBA every 5 seconds from when I click a button. the name of my shape is "Rectangle 1".

**1**

vote

**0**answers

23 views

### Word converting linked excel objects to text table when updating

I have several Excel tables that I have embedded as linked objects in a Word file. They look great for the monthly report. However, when I go to update the Word doc the following month with updated ...

**3**

votes

**2**answers

38 views

### Define value of a column by another column in Excel

This seems like it should be so simple! I need to define column B by column A
If column A is equal to any value in the array "taco,burger,spaghetti" column B should read "food", if column A is equal ...

**2**

votes

**1**answer

31 views

### Why does Saturday show up automatically when I use the “TEXT” function in Excel?

I've been trying to figure this out for the past two days and it's driving me nuts so I'd greatly appreciate any help with this.
I'm updating a vacation request form so that when someone types in the ...

**0**

votes

**1**answer

122 views

### How to remove non-duplicate records in Excel-2010

How do I 'Remove Non-Duplicates' keeping only the duplicate records? I know I can highlight duplicate records with a different color, but I'd prefer to remove the non-duplicates instead, as I don't ...

**2**

votes

**2**answers

38 views

### X axis labels with “super-categories” or “headers”

How do I make the X axis labels of a column chart looks like this? i.e. with, for lack of a better name, "super-categories" or "headers", like the labels "All sites", "All sites excluding LR" etc. in ...

**0**

votes

**1**answer

33 views

### Count from a cell with value to the end of row and dividing total by number of number of months regardless of blank

How do I write a formula that will auto start sum from the first cell with value though to the end which including blanks, and then divide the total by number of cells from the one with value through ...

**0**

votes

**3**answers

48 views

### Saying in Excel: IF this is true, then show me the cell two below

Hy there,
i am trying to create an automatic invoice and probably i am making my life much more complicated than i should.
here is my problem... i have these tables (short version)
Name
Street
Place
...

**0**

votes

**2**answers

80 views

### Compare two columns in two sheets

I have another question, even though the last one i asked is still pending. I have a large data of over 100,000 records. I am using the code below to loop through the data so that any duplicate ...

**0**

votes

**1**answer

106 views

### Creating chart in Excel where data for X-axis (horizontal) is non linear and extrapolating value

Have some data of the following form:
X | Y
----+-----
3 | 42
4 | 57
6 | 92
11 | 119
19 | 316
(NOTE: The above table is made-up data)
What I'd like to do with MS-Excel is to plot 2 ...

**0**

votes

**1**answer

39 views

### How to write down degrees, minutes seconds in excel and convert them later to decimal degrees?

I have the locations of many points as degrees, minutes, seconds (Handwritten). How to insert these locations in excel and convert them later to decimal degrees?