The 2010 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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