Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. If your question is about programming Excel in VBA then also tag it excel-vba. If it is about an Excel formula or worksheet function, then also tag it worksheet-function.

learn more… | top users | synonyms (2)

0
votes
1answer
15 views

How to use INDIRECT with a SUMIF formula for a date range

I'm trying to get a SUMIFS formula to dynamically work with multiple tabs in an excel workbook. I have numerous tabs in this workbook, each that contains client data I update daily. In the example ...
1
vote
1answer
4k views

Query parameters in an external connection to sql server

I want to do exactly this:http://dailydoseofexcel.com/archives/2004/12/13/parameters-in-excel-external-data-queries/ but I want to do it in Excel 2010 and also I am querying SQL Server instead of MS ...
0
votes
1answer
5k views

How to customize Paste Value Excel Short Cut

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code. I would like to set the keyboard shortcut to Ctrl d but Excel pops up an ...
0
votes
0answers
7 views

Excel Solver - Can't set integer constraint on certain cell

I have a production programming exercise that I'm supposed to solve by using the Excel solver. However, I am not able to set an integer constraint on a certain cell that I need to be integer only. I ...
3
votes
5answers
26k views

Excel 2010 takes forever to open

I have identified a very interesting problem with Microsoft Excel 2010 on a client's computer. When opening an Excel file located on a shared folder or mapped network drive, Excel takes 2-3 minutes ...
1
vote
2answers
8k views

Splitting concatenated Excel columns at spaces?

An application that I use generates data in the form of a text file, with the values separated by spaces. When I load this into Excel, a column of data I'd like to extract is melded to several other ...
0
votes
0answers
21 views

Update Table based on Range start value and end value

I have a set of data that uses a primary key of month of the year by numerical value, e.x. Month 1, Month 3. I am trying to update my table and its values from the raw data set based on a user entered ...
1
vote
1answer
36 views

How to create a preset for printing a workbook in MS Excel

I need to create a Default preset for 1-Click-Printing a workbook in MS Excel. This includes predefining Sorting and Filtering values, Adding text to top and bottom of the printed document, And ...
0
votes
0answers
17 views

MS office character replacement [on hold]

I often need to replace a character in Excel on a character that follows after it or preceeds it in alphabet. This letter is part of formula that takes data from different columns in other table. For ...
1
vote
2answers
30 views

Excel Formula difference between two dates

I have two dates as the following , I want to get the duration spent between them. 6/29/2015 12:18:04 PM Regards,
2
votes
1answer
15 views

Excel grab address to start y values series

I have the string $F$50 created by the CONCATENATE function. I also have a scatter plot where the selected data is like this: =SERIES(,data!$A$4:$A$404,data!$F$4:$F$404,1) I want to replace $F$4 in ...
2
votes
3answers
30 views

How to convert integer column to time column?

I am trying to format an integer column to a time column, but the values all end up as 12 like this: 12 12 12
2
votes
1answer
3k views

64-bit Excel 2010 Solver - Solver32.dll not found

I am trying to use Solver in 64-bit Excel 2010. When I run Solver, it opens the solver window, states that it has results and then popups the following error message: Run-time error '53' ...
1
vote
1answer
21 views

Is there a way to configure Currency or Accounting dropdown in Number Ribbon?

Is there any way to configure the list of currencies showed in the Ribbon (see screen shot)? My most used currency, $, is not available in the default list and I can't found out how to modify this ...
2
votes
3answers
44 views

How to get unique values from data range in Excel?

I have a column whose rows are: Facebook, Skype Facebook, Skype Facebook, Twitter, Skype Facebook, Twitter Facebook, Skype Facebook, Skype Facebook, Twitter, Skype Facebook, Skype, ...
1
vote
2answers
3k views

MS Excel: Can I link images using a relative path?

I am working on an MS Excel document that contains a lot of (around 200) images. They are currently saved within the document, so the file becomes huge and working gets very slow. Linking the ...
0
votes
1answer
29 views

Excel: Is it possible to copy cells only if cells match in other columns?

If it's an EXACT duplicate, not just some answer that MAY suggest an answer then please provide the link in a comment. Say, I have dates in column A of Sheet-1, and also dates in column A of Sheet-2. ...
0
votes
2answers
21 views

How can i match columns that are not adjacent to each other?

How can I match column A with other C and E (columns are not adjacent to each other) and fill 0 in column G if column A matches either column C or E. If column A does not match neither C or E fill the ...
0
votes
1answer
40 views

Concatenate with column header but omit blanks with Excel for Mac 2011

I want to modify this formula: =A$1&": "&A4&" & "&B$1&": "&B4 Sample: Column A: a info & Column B: b info So that if there is a blank cell the Title and the blank ...
1
vote
1answer
2k views

Match unsorted Excel data from two columns (products) to assign value to a third column (prices)

I have four columns: Column A has a part number, column B has a new price Column C has a part number, column D has an old price. Column A and C are not identical nor do they have the same number of ...
1
vote
1answer
11k views

Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...
2
votes
1answer
5k views

Can I save an Excel chart to a PDF document with the chart's exact dimensions?

I want to save (or 'Publish') an Excel 2010/2013 chart to a PDF file whose dimensions will be exactly those of the chart - not a full white page with the chart on it. Can this be done somehow? ...
0
votes
1answer
4k views

Call PowerShell script from Excel macro

I'm trying to call a PowerShell script from a macro in Excel. I have seen a number of examples along the lines of: retval = Shell("powershell ""C:\MyTest.ps1""", 1) When I try to use this, ...
0
votes
1answer
37 views

Is there a way to exclude keywords in a VLOOKUP formula?

I have 3 sheets in Excel. In the 1st one there is a column with hotel names and another one with ID. I want to get that ID from the ID column on the 2nd sheet where I have the names as well. The ...
3
votes
2answers
1k views

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...
1
vote
1answer
7k views

How to move the y axis to the left in excel , scatter plot with x-axis log scale?

I have my scatter plot with x-axis log scale like below: I want the position of y-axis moved to the left. How can I do this?
16
votes
8answers
6k views

How to stop Excel following hyperlinks when I click on them?

In Word I can use Ctrl+Click on the rare occasion that I want to follow a link rather than, you know, do the editing that Word is actually for. Is there some way to get similar behaviour in Excel ...
0
votes
0answers
27 views

How can I make a code that checks for its validity [on hold]

Suppose I have the source code in any language and I give my code to someone and I dont want them to modify my code. So can I write something in the code that can check the validity of my code(i.e the ...
0
votes
1answer
5k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
-1
votes
0answers
17 views

excel 2010 VBA insert column headers

I have a piece of VBA code (Excel 2010) that generates tables with 5 columns x 6 rows. There is an option to input the number of tables to be generated, as required e.g. 1 or 6 or 10 etc. basically ...
1
vote
1answer
10 views

Paste special text leaves trailing spaces in Excel

I wrote a script that creates an HTML table like this for a coworker: <table> <tr> <td>06/21/2014</td> <td>AAA</td> </tr> ...
0
votes
2answers
7k views

Copy drop down list from excel 2007

How can i copy a entire drop down list from excel 2007 one document to another excel document, i have tried copying and pasting special, some forms told me to copy it through data validation process ...
2
votes
0answers
32 views

Is it possible to add a custom calculation for a top level row total in a pivottable?

My Pivot Table has the following format Manufacturer MPG - Nissan 10 - Petrol 35 - Model A 30 - Model B 40 - Diesel ...
0
votes
1answer
13 views

Excel Formula change and remove

The numbers on the form are for two different references. 2015-##### (five digits after year) is the way it will be entered. When the user enters that I would like to enter in another cell the result ...
0
votes
2answers
26k views

Scatter chart, with one text (non-numerical) axis

Lets imagine I manage 100 pizza stores. I want to plot a chart each day, of how long deliveries are taking. My data might look like this: London 23 London 22 London 44 London 18 ...
0
votes
1answer
12 views

How to copy tab-contained text from Excel without quotes?

I've noticed that a cell that contains a tab is copied with quotes embedded. I'm looking for copying such kind of a cell without the quotes. Illustrative Example I've 5 cells; A1, A2, A3, A4, and ...
1
vote
1answer
22 views

Excel 2010 error message when opening .xlsm files

I'm trying to open a .xlsm file in Excel 2010 when I receive the error: "There was a problem sending the command to the program" Once Excel is open, I am able to open the file, but if Excel is ...
0
votes
1answer
3k views

How to Find and Replace worksheet name in a formula?

I have 100 worksheets with different names saved in a folder. I have another worksheet in another folder where I conduct analysis of data from one of those 100 worksheets. In this analysis worksheet, ...
1
vote
4answers
71 views

How can I disable Excel 2013 on Windows 8 from asking for login credentials on some Web Query calls?

We've built a web query view in our application, returning some reports as a simple formatted table (with PRE tags etc. as required). Our app requires a login naturally, but its basically an API ...
1
vote
4answers
30k views

Extracting Data Between two Characters in Excel

I have the following format in Excel and I am trying to extract the data between the characters: First Last <flastname@xxxx.com> I need to extract the email address between < and > into ...
0
votes
1answer
17 views

Google Spreadsheet =Filter in excel

I have this formula in google spreadsheet that uses the =FILTER functionality but I can't seem to find the corresponding syntax in excel. Specifically the formula is as follows: ...
0
votes
0answers
49 views

Excel does not update formulas values after filling source cells with values

I do 3 steps: Based on a template, I create a new Excel file through code (it works fine): Shared Sub FillExcel() Dim extension As String = ".xlsx" Dim sourcePath As String = "c:\Temp\libro" & ...
0
votes
2answers
19 views

Assign category to data based on range

In Excel, how would I take numbers from one column and assign them to a category in another? E.g., if I set ranges that correspond to certain words 1-10=Beginner, 11-20=Intermediate, etc. How would I ...
0
votes
0answers
8 views

Crash when using Get External Data From Web in a macro

Is there a way to disconnect IE from Excel when using the "Get External Data From Web" and use another browser such as Chrome or Firefox? I've been having problems where IE stall/hangs and the ...
0
votes
2answers
2k views

Filter data in sheets from a master sheet

I have a 'master sheet' with lots of furniture data in it, in column A there are the suppliers names. What I would like is to be able to have my master sheet with all the info and then sub sheets ...
1
vote
2answers
30 views

How to identify a cell in excel?

I have a massive excel sheet with a few thousand rows and columns. I need to identify those rows that have a certain code. The code can be in any column. Here is an example table to make this more ...
0
votes
0answers
17 views

Conditional Formatting using Excel writer

In Excel, using Interop dll I have following code. objWorkSheet.Range[objExcel.Cells[intHeaderRowCnt + 2, 6], objExcel.Cells[intCellRowCnt, 6]].Formula = "=RC[-3]-RC[-1]"; ...
0
votes
0answers
27 views

Using filter in Excel

I have an Excel file which contains details of all the school students from A to Z. Out of it, in a separate sheet created FEES DUE FORM for each class that contains only ROLL NO., NAME from APR '14 ...
1
vote
1answer
4k views

Unable to insert rows or columns in Excel 2013

I'm using Office 2013 on Windows 7. Few times, I have not been able to insert rows / columns in a some of the Excel spreadsheets. I tried the following before searching on the internet. Use ...
0
votes
2answers
42 views

Populate missing entries from one sheet to another

I have two Sheets in Excel. For this example, Sheet 1 and Sheet 2. Sheet 1: 100 records with Name, Location, Gender Sheet 2: 100 records with Name, Location, Age The sources of the data are not ...