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

Which versions of MSExcel support the 'WEBSERVICE' function?

Pursuant to Excel formula to take out quotations , I saw that it's possible to use a form of web-querying in certain versions of MSExcel. Incidentally, what I saw was: ...
0
votes
0answers
6 views

Generate string from table cells

I am using Excel 2008 for Mac. I would like to have a cell generate a string based on the contents of the other cells on the same row. For example, say I have the following table headers: bob, ...
0
votes
1answer
9 views

Error: Text date with 2 digit year

For some reason the dates I enter into my Excel 2013 spreadsheet show up with "Error: Text date with 2 digit year" for other Excel user on another computer. This breaks some formulas in my ...
-1
votes
1answer
26 views

Formula issue Microsoft Excel

I need help urgently for a work problem. So basically, the summation of opening stock and production give total stock. While closing stock is ((opening stock+production)-sale)) and stock cover is ...
-1
votes
0answers
22 views

Excel Sort multiple rows at once

How do I sort all the cells of each row in a worksheet? I have 3 columns: Option 1 > Option 2 & Option 3; Not all rows (60+) are sorted A, B, C I can sort each row but due to the number of ...
-1
votes
0answers
16 views

Macro in excel to manage more than one worksheet?

I need to set a macro to manage the "footer elements" in many excel files, and each file has many worksheets. I set the macro both with relatives reference and not, but I can view the modify only at ...
0
votes
1answer
27 views

Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help. I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls. B.xls contains some macros in it's ...
0
votes
0answers
18 views

Save worksheet as a seperate file

I would like to know if there is an option in Excel 2010 where you can save a specific worksheet in an Excel file into another file, without having to open the destination file. Thus without having to ...
1
vote
3answers
29 views

Adding a space to the beginning of every cell in excel [on hold]

I have a column of data, and I would like to simply add a space to the beginning of each cell. How can I do this? It should be like this: Original: 1 2 3 4 After: 1 2 3 4
0
votes
0answers
15 views

Summation series in Excel

I have been trying with no success to implement a summation formula in Excel I want to perform a summation from n=1 to X [ xPn ] where P is permutation and X is a fixed number in a cell.
2
votes
1answer
36 views

Excel formula to take out quotations

Does anyone know a way to get excel to not include quotations in a value? I have the formula: =WEBSERVICE("http://finance.yahoo.com/d/?s="&A3&"&f=p2") so that I can pull the % ...
0
votes
0answers
14 views

Merging all Data into one sheet with their respective sheet name in Excel

I have a excel file with near about 80 sheets. what i want is to merge in one sheet with their sheet name in column like this Any Workaround for this task...?
-1
votes
0answers
11 views

Preventing Multiple Letters to One Person in Mail Merge

I'd like to use Mail Merge in Word using an Excel sheet to send the following letter to people who have borrowed my gardening tools: «GreetingLine» My records indicate that you have borrowed a(n) ...
0
votes
0answers
8 views

Regroup rows based on a column value

I have the following data: Last Name | First Name | Division Doe | Jane | A Doe | John | B Does | Michael | B So, every user is assigned to a group. Now what I would ...
0
votes
1answer
17 views

Excel changes typed formula

Why does excel change cell entrys Example: Initial entry +20+20 Next time I click on cell the contents of cell now is 40 It is not consistent on all cells
0
votes
0answers
12 views

Excel 2010 key board shortcuts extremely slow

I'm using Excel 2010 and I'm getting some strange behaviour when i try to use the keyboard short cuts. For example if I type Alt-E-S to bring up the paste special window it can take anything up to 10 ...
0
votes
0answers
16 views

Excel recover read-only edited file

I needed to edit a file which was sent to me as an attachment in email. I opened Outlook and then opened the attachment in Excel. The Excel window appeared probably in read-only mode which I didn't ...
0
votes
0answers
11 views

LWD, WTD and MTD Split

All, I have a list of data and I would like to do a summary table that automatically calculates entries for the last working day, week to date and month to date. Sample below. So in my summary ...
0
votes
0answers
11 views

Error in importing the numbers in scientific notation

I am importing values into Excel from R Console which are in scientific notation (1.920943e-10, 7.580894e-05). Excel is not treating them as numbers instead text. How to resolve this ? Thanks
1
vote
1answer
13 views

Dealing with absolute references in a conditional formatting macro

Say I have the following simple data in Excel: A B C D E F G 2 1 3 2 5 4 2 4 2 1 3 2 5 2 1 3 2 4 I want to set up ...
1
vote
0answers
47 views

Convert single row to multiple columns in excel

In Excel, how can I convert: A 1 A 2 A 3 B 1 B 2 B 3 to: A B 1 A 1 2 3 2 B 1 2 3 Where characters are in first column and numbers are in second column. Any help would be ...
1
vote
1answer
20 views

After pasting data, how do you navigate cell contents with keyboard arrow keys in MS Excel?

Using MS Excel 2010 I can copy ASCII plain text from a separate text document and paste the text into a cell (I first enter cell edit mode before pasting with Ctrl+V or Shift+Ins). After pasting, ...
0
votes
1answer
15 views

How to transpose two cells data at a time from 2 cells to multiple rows

I have Excel data in the below format: Excel Std Row: A B C D E F G H I J 1st Row Data: 1 1 2 2 4 4 5 5 6 6 Now I need output as below: A B ...
0
votes
1answer
26 views

Visual Basic and Excel data streaming in real time

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
0
votes
0answers
18 views

All Data Option Filter Validation

I am creating a dashboard that has five inputs that filters my data by the custom data validation combination. My dashboard updates correctly based on the custom combinations, but I am unable to add a ...
1
vote
1answer
27 views

Copying cells to another sheet and inserting rows for the copied cells

I am trying to create a sub that copies information from one form (which has four cells) to another sheet. When it copies the information it also creates a new row. Each form has a maximum of ten ...
0
votes
1answer
49 views

What is need to improve percentage [on hold]

I work in a school and attendance is something we wish to focus upon. I would like to be able to calculate the following: If a student's attendance falls below 90%, I would like to calculate in ...
1
vote
1answer
19 views

Microsoft Excel 2013 Changing Date Automatically to current Date

I have an excel formula that I am using to automatically add the date to the cell next to the cell. I use a drop down menu to select a value. Is there a way of then stopping this date from changing? ...
2
votes
1answer
33 views

Finding Common word from two columns and returning value

I've two collumns in excel and I want to see if there is a common word(s) betweeen my cells, for instance: Cell A1: 76A08, 26A65, 22A26, 2A01, 12A05 Cell B1 I've : 26A65, 22A26 In cell C1 the ...
1
vote
2answers
29 views

Need to count the amount of times -1 appears above a certain cell

I have the following Excel Spreadsheet - Hy Newcastle 042216 -1 Not Matched 1000 Hy Newcastle 042216 6461735 Khanyile;Florence Success 1000 Hy Newcastle ...
0
votes
1answer
15 views

How to compare differences for multiple possible pairs of cells in Excel

In Excel, I have 7 columns of data (numbers) spanning 100 rows. For each row, I want to check whether at least one number exceeds all other values by a certain value (say 0.2 or greater). If so, the ...
-1
votes
0answers
21 views

Copy paste to excel [on hold]

I am tring to copy from browser and paste to excel it is taking 7 min, can any one say what is the problem The same if I am working with production url it is taking 1 min. Please I don't want to use ...
0
votes
1answer
32 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 ...
0
votes
0answers
11 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 ...
0
votes
0answers
30 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 ...
2
votes
1answer
16 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
33 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
1
vote
1answer
24 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 ...
1
vote
2answers
31 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,
0
votes
2answers
26 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
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 ...
-1
votes
0answers
17 views

excel 2010 VBA insert column headers [on hold]

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 ...
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 ...
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. ...
1
vote
1answer
12 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
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 ...
0
votes
1answer
14 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 ...
1
vote
1answer
33 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
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
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: ...