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
0answers
3 views

Move each Cell after column A on new line

I would like to export some data into MySQL, however before that I would like to format the data. I am not sure how to explain it, so I made some screenshots. How could I turn this: Into this? 1 ...
0
votes
1answer
21 views

Convert custom date to standard format

I have a worksheet that has custom dates e.g. August 26th 2015 and I would like to convert this to 8/26/15 Is this possible ?
0
votes
1answer
86 views

Automatically format cells as currency from .CSV when importing into Excel

When I import a .CSV file into Excel, how do I get all cells which contain a number to be formatted as currency? Currently, if the value for the cell contains the dollar sign ($), it becomes formatted ...
0
votes
2answers
31 views

Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc. I'd like to have a stacked bar chart that lines up with these intervals, but so far ...
0
votes
1answer
11 views

Look up specific string in row (not column) and return value of cell x columns left of that location

My data looks like this: Sheet 1: A B C D E F 1 2 3 a b c 1 2 3 a b c 1 2 3 a b c Sheet 2: A B a b c Now on Sheet 2 in Column B I would like to return the result of: look up each value of ...
0
votes
1answer
2k views

Excel scatter graph fill inside shape

I would like to fill the area between two graphs. My data is in the following format: x y 0 0 1 1 2 4 .... 0 0 As you can see they start and end at the same point. For my data it draws a chart ...
1
vote
2answers
5k 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
0answers
2 views

Failing to use a split cell range as data source for a pivottable

I want to create a pivot table from this table I have, but I want to leave out some of the rows. So, suppose I want to keep the header row, leave out the next ten rows, and use the next 10 rows. This ...
0
votes
1answer
26 views

If(ISERROR(INDEX combination produces “You've entered too many arguments for this function” error

I have two working formulas and I want to combine them both: This identifies a unique item number in a list =IFERROR(INDEX($B$3:$B$16, MATCH(0,COUNTIF($E2:E$2, $B$3:$B$16), 0)),"") This ...
-4
votes
0answers
10 views

extract data in excel [on hold]

I have to extract records to other sheet by key field from a data base in excel sheet using Excel VBA. The code has to go over all records and when the key is Change he takes the next key and extract ...
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
0
votes
1answer
4k 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
3answers
24 views

Excel VBA: Count # of Delimiters

I have the following code: Sub CopyTest() Dim skuRow As Integer Dim curSku As String Dim numSkus As Integer Dim impType As String Dim copyRows As Integer Dim supAcc As ...
5
votes
7answers
24k views

Unable to get Excel to recognise date in column

I constantly have problems working with dates in Excel, I must be doing something wrong but I don't understand what. I have a spreadsheet, exported from our exchange server, that contains a column ...
1
vote
1answer
21 views

Excel chart: Poor plot of a straight horizontal line, due to settings that use “Major Unit: Fixed” for the vertical axis

I have a table of data that is the source for a chart. I import different data into the table often to plot it in the chart. In the settings for vertical axis, I selected "Major Unit: Fixed (at 1.0)", ...
0
votes
1answer
22 views

Match each row against all other rows

I have 53 rows with 25 columns nand it's all txt values. Is there a formula that will match each row against all other rows? I basicaly need a similarity matrix and am wondering if there is a shorter ...
2
votes
1answer
447 views

Add-Ins not loaded in Excel, when started via opening a file

I'm using Excel 2010 with TFS 2010. When I start Excel directly, "Team" and "Load Test" are loaded. But, if I double click on an Excel file, then Excel started without loading "Team" and "Load ...
2
votes
1answer
20 views

Varying Format Part Number Sort Issue

(Current Sort Sample:) 2-1203-4 2-1206-3 2CM- 3-1610-1 3-999 … AR3021-A-7802 AR3021-A-7802-1 B43570- B43570-3 I am working on an 8000+ record parts list. The challenge I am running into is that ...
2
votes
1answer
17k views

Importing CSV files into Excel using a macro

I want to develop a macro where in my Excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the ...
0
votes
0answers
17 views

Excel x64 file corruption in .xlsb files for Office 2013

I have a number of Excel files, all created in Office x64, all in .xlsb format and all containing macros. Every now and again, these files become corrupted and I cannot get them to run. I can however ...
5
votes
5answers
44k views

How do you insert the current file name in Excel?

I am trying to view the file name that I am working on in the Excel spreadsheet of interest using a formula. For example if the file was called workbook1.xlsx then I would want cell A1 to show ...
1
vote
3answers
33 views

How do I use the AND function and the MATCH function together to get something that is not “No” and has not been returned previously

I have the following data and need to return all values that aren't "No".  I.e., I want to create, in another column, a list of all the values from Column E that aren't "No".  There will never be ...
0
votes
2answers
62 views

How to tell Excel that “Years” are “Years”, not data

I have googled everywhere about this but no solution found. I have three columns in Excel: A: Years, from 1960 to 2013 B: Maize production (in tonnes) C. Wheat production (in tonnes) If I make a ...
0
votes
1answer
22 views

Check which (multiple) cells in column A contain substrings specified in column B?

In column A I have M&A deal descriptions that mention company names. In column B I have company names, for each of which I want to see where it is mentioned in column A. What I'm having trouble ...
2
votes
0answers
16 views

MS Excel 2013 function TODAY() not updating unless source file is open

I use the TODAY() function in an excel worksheet which is accessed using MATLAB (i.e. I don't read the worksheet directly). Now I have to open the excel file just to update the TODAY() function, and ...
1
vote
1answer
4k views

How to print an Excel Spreadsheet as Grayscale?

I would like to print my filled cells in a different color to match the rest of my document. The filled cells contain green background and blue font. I want the cells to automatically print to grey ...
1
vote
2answers
2k views

Excel: How to plot a stacked scatter set

I have two datasets that share the same x values, but each have different y values. I would like to plot both on the same graph, however I do not want the secondary y-axis on the right side of the ...
2
votes
0answers
18 views

Unlock Excel VBA “Find” window location

When editing VBA code the FIND window (Ctrl F) appears at the bottom of the screen. It can be manually re-positioned but upon re-opening it appears at the bottom again. It used to open in the last ...
6
votes
3answers
96 views

How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this: funkiana,23.55,-99.866 funkiana,24.634,-98.701 funkiana,24.717,-98.901 geminiflora,22.25,-104.6166667 ...
-4
votes
0answers
17 views

I want to develop the splitting one row into multiple rows in Excel

You provided an excellent answer on how to convert Excel data in rows into a vertical column or series of columns. The page is: How do I split one row into multiple rows with Excel? In that ...
1
vote
2answers
12k views

How do I calculate the total difference between two columns of figures in Google spreadsheet/Excel?

Usually I would just calculate the difference of each row like this: =B1-A1 Then I would sum up the values of the column like this =SUM(C1:C10) and get my desired value. I don't want the C-column. ...
1
vote
1answer
4k views

How do I add values in column B if column A contains the same employee surname more than once?

State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once? I have been using what I ...
4
votes
2answers
12k views

Why can't Excel open a file when run from task scheduler?

I wrote a powershell script that opens an excel workbook and runs a macro. When I run that script from PS console, or even from command line using powershell.exe script.ps1, it jus works. When I set ...
0
votes
0answers
23 views

Sum if function - data missed [on hold]

I'm calculating a value based on 3 criteria. One of the values being calculated is incorrect as one of the criteria is not being picked up for one of the lines. E.g I'm counting hours based on ...
-2
votes
0answers
22 views

Dynamic text in Word based on Excel output

I am trying to print a brochure for clients. The client selects the options from an excel sheet. Based on the selections, i prepare a word output, which has some standard terms and conditions and some ...
0
votes
0answers
8 views

Fetch Google Sheets data with Excel Power Query

I am using Excel 2103 and Excel power query. The fetch data from web works fantastically on most websites, however I cannot get it to work on Google Sheets I have tried using the share URL as well ...
1
vote
1answer
16 views

Copy an excel file with Macros and New Tabs in the ribbon to another computer

I'm working with Microsoft Excel 2013. I'm using couple of macros I did and I made a new tab in the ribbon menu which shows the macros I did so that I can click on the this created tab then click on ...
5
votes
4answers
25k views

Excel - columns to one cell

Can you have a column of data moved to a single cell with commas separating the values that were in the column? Kind of reverve text to columns. ie; 1 2 3 4 5 1,2,3,4,5 in a single cell.
0
votes
1answer
176 views

How do I pull the ASIN code from an Amazon url in Excel?

How do I pull the ASIN code from an Amazon url in Excel? Variable length URL's, example: Want to derive the cell result : B00BQ59SYM from this ...
-1
votes
0answers
24 views

Restricting a cell value in Excel

I need to restrict a cell with following two conditions: text value which equals to APPLIED FOR (11 characters) alphanumeric value with minimum & maximum of 11 characters Kindly help.
3
votes
1answer
35 views

Excel date month issue

I am working on projects that come in every 4 and a half month. I want to make a calender so I can see when the deadline is for each project. I have a formula that adds up 4 months and 14 days. (4,5 ...
2
votes
0answers
36 views

Excel array formula and structured table date header works with double digits and fails with single digit dates

I have a formula that matches the date with a structured table header row. I have extensive code that deals with the text string nature of this row successfully. However, when trying to check visible ...
1
vote
2answers
18k views

Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total. ...
0
votes
1answer
2k views

Changing cell values based on another cell

Lets say that I have 3 parameters/cells: High (Cell A1) Medium (Cell A2) Low (Cell A3) the fixed values for these cells are 2, 2 ,2 how can I change the value of cellA1 based on the changes of ...
0
votes
0answers
25 views

Automated Goal Seek - Excel

I have been using goal seek successfully to back into a known number. This works great with a handful of lines - now I need it for 100s (probably 1000s) of lines. Any help would be greatly ...
1
vote
1answer
42 views

Excel : how to put a literal dot into a cell format

Whenever I put a dot character into a custom cell format Excel will interpret it as if I want a decimal separator in that location of the format. The problem being that decimal separator changes with ...
-3
votes
0answers
26 views

Excel Formula to show number of months to break even for ROI

Trying to create a formula to determine length of time (in months) to reach ROI. Column A - Start Date Column B - Remaining balance until ROI (Investment less current profits) reflects a (negative) ...
2
votes
2answers
497 views

Excel version confusion

I got an Excel file, actually it's a zip file which contains many folders and files including sheets in XML format. When I try to open it, Excel 2003 says "The file is not in a recognizable format" ...
5
votes
1answer
29 views

All Public Variables in VBA Macros in my office stopped working this morning

It turns out, I'm an idiot (or, at least, hopelessly inexperienced with this whole software development thing). The below is what I spent my whole day panicking about. I'll write an answer detailing ...
3
votes
1answer
73 views

Extract number from complex string if it falls in a given range

I need an Excel formula (or VBA macro) that will allow me to extract a value from a string. The string is a sequence of words, separated by spaces, in a single cell. I want the word (representing a ...