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)

2
votes
1answer
41 views

Excel Number Input restrictions

I have a spreadsheet that I have cells that I want to restrict entry to be either a whole number, or a half number. Allow say 5 or 5.5 or 9.5. NOT allow say 3.2 or 5.7. I'd like to do this ...
0
votes
2answers
33 views

How can I find out which parts of an Excel workbook are the biggest in size?

I have an Excel .xlsx that weights 47MB. I'd like to know which parts of the workbook are the heaviest and work them, since I haven't made much progress manually trying to identify and reduce the ...
0
votes
1answer
15 views

Removes rows (based on condition) and copy cells (based on condition)

I have to modify a huge VBA script, I am new to VBA and I must also say that I am not loving it :( I need some help writing an efficient For-loop, let me explain with an example. During the first ...
0
votes
2answers
21 views

Two columns (pounds, kilos) convert and fill opposite column depending on which data is entered.

I'm trying to keep two columns of data. One in Pounds and one in Kilos. (1 kilo = 2.204 lbs) The problem is that when I add a row, it might be in kilos, it might be in pounds. Is there a formula I ...
0
votes
2answers
21 views

Assign triggered code to multiple images - Excel VBA

I wanted to assign some specific actions when clicking on one of the images I have inserted in my Excel sheet. The problem is, I got 52 images (Poker cards for those wondering). So, my question is, is ...
0
votes
1answer
30 views

Importing an excel sheet with many empty cells into R

I have a big excel sheet that have lots of empty cells. I'd like to import it in R. I'm fine if in R, all the empty cells are replaced by "NoData". Replacing all empty cells by "NoData" on Excel and ...
0
votes
2answers
29 views

Graphing patient data, multiple dates, multiple patients

In Excel, is there a way to graph multiple series from one column of data? I have lab values for patients. Column A is date, column B is patient identifier, and column C contains all the lab values. ...
0
votes
0answers
22 views

merge two functions to plot 3D graphic on Excel or gnuplot

I study the emission of particles from a component. I get a nice curve of the variation of particles concentration C(t) on time(t) using Excel. I have also a curve of the variation of particles ...
3
votes
2answers
29 views

Automatically updating bar chart?

So for a project at work I have a table in excel that contains numbers for each month of the year up to this one in four categories. It looks (a bit) like this: ...
0
votes
2answers
26 views

Correct function to use in Excel with “word” variables

So I have a column header saying Home City (without the quotation marks). However, I want to assign that Home City to a Province (which is equivalent to a State in America). I don't think the IF ...
1
vote
1answer
34 views

Countifs array with number of days

I'm looking to see how many days people are around between certain blocks. e.g. with people and the days they are around for listed in the first table (A1:C5) and the blocks in the second table ...
0
votes
2answers
40 views

Where does Internet Explorer save the files which I have opened? [duplicate]

I opened an Excel file from Internet Explorer, worked on it for 2 hours and saved it. But now I can't find the file. The file was really important. Is there any way I can retrieve it? I'm using ...
0
votes
2answers
28 views

Cannot delete created excel table

I have created an excel table. However, I now want to delete or change it because my range changed. However I can't delete it in the excel Name Manager: Any suggestion why I cannot delete it? ...
0
votes
1answer
28 views

How can i fix the mean of a column of randomly generated values?

I want to generate a column of random values in excel using: rand() But in such a way that the mean of those values is always 1. Is that possible? Thanks in advance!
0
votes
2answers
23 views

Understanding IF() statement

I am trying to update a spreadsheet that was created by an employee that is no longer with the company. I have been successful in decoding and update all but 1 formula. ROUND(C6,0)*IF($D$3="Y", 42, ...
1
vote
2answers
21 views

How can I stop Excel From Updating Links When Copy and Pasting Cells Linked to Other Workbooks?

Summary of the problem: I would like excel NOT to link to the spreadsheets links I'm copy and pasting until I have the entire spreadsheet setup. Overview: I have a worksheet that acts to aggregate a ...
1
vote
1answer
21 views

In Excel 2011 on Mac, how to return a non-blank matching value with vlookup?

I have a list of domain names and their registrars on one sheet, and the same list of domains and other data (but not registrars) on another sheet. I need to get the registrar name from sheet A, to ...
1
vote
1answer
34 views

When pasting, how can I ignore hidden columns in the destination range?

I have two worksheets s1 and s2. Data on s1 looks like: +---+-----------+--------+------+ | | A | B | C | +---+-----------+--------+------+ | 1 | scarecrow | tinman | lion | ...
0
votes
2answers
26 views

Excel: DD/MM/YYYY stored as text…need to convert to Date format

I have a slight problem. It would be easier to post an image but I can't because I don't have 10 reputation. Anyway I have a column with the heading "Birth Date", and dates entered in DD/MM/YYYY ...
0
votes
0answers
20 views

Export sheets and defined range to PDF

I'm trying to select these sheets in my project: Forside, Begrundelse, handelspris, dokumentation. In my dokumentation-sheet is a range defined in pages and I don't know how to add the defined page ...
2
votes
0answers
38 views

Automatic scatter plot in Excel 2010

I have two quite large data sets of which I want to plot every line in one plot. The pattern is the following: x-axis: Set one (Colonne 1-6) y-axis: Set two (Colonne 1-6) Now I want such a plot for ...
0
votes
1answer
20 views

How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package?

How to load above 2 million data from SQL Server to CSV/Excel using SSIS 2008R2 package? The Package needs to create new excel/csv file automatically once the first file is filled with maximum number ...
2
votes
0answers
58 views

Excel 2013, can data be re-sorted automatically?

Is there a way to re-sort automatically? I have automatically updating cells and depending on incoming values the rankings change. I am looking for a way to have the table resort automatically ...
0
votes
1answer
20 views

Why doesn't isformula() work on Excel 2011 for OS X?

Supposedly, Excel has isformula(), but all it ever gives me is #NAME? For me, isformula() is not even listed in Excel as a valid function at all! Nor is there any mention of it in the help ...
0
votes
0answers
38 views

Learning a new Programming language for creating Docx files [closed]

I currently have experience in using Matlab (for university) but now no longer have access to the license. There is one specific task that I am looking to perform and am prepared/expecting to learn a ...
0
votes
2answers
24 views

Excel- Merge cells with same text in one column and add time values in another

I have first column containing values in text and a second one containing duration for each value. I would like to merge two or more cells which has the same value in the first column and add the time ...
0
votes
1answer
18 views

Conditional formatting in Excel 2013

Hi I want use conditional formatting. On this values: everything works, but when i change values (mid and max values are similiar) to: conditional Formatting do not works. What I do bad?
-2
votes
1answer
30 views

Parking time calculator

In our section, the first 45 minutes are free for parking. After that, small vehicles cost 10 dhs per hour, and big vehicles cost 30 dhs per hour. This means if a driver parks a small vehicle at ...
0
votes
1answer
28 views

Merge Multiple Excel File

I need to merge a few hundred Excel files into in one Excel file. Each Excel file needs to be merged into its own worksheet in the workbook and the worksheet it's merged to needs to be have the name ...
1
vote
2answers
51 views

Excel Lookup adds double quotes to string

I'm using this formula to get value form a table =LOOKUP(C11;Alias[A];Alias[B]) where C11 = 12354567 But when I use =LOOKUP(LEFT(C11,7);Alias[A];Alias[B]) where C11 = 12345678, the formula does ...
0
votes
1answer
11 views

Identify Image in Excel - VBA

I have an Excel sheet, and I want to create some macros using VBA. Specifically, I want to change an image with a predefined one, every time I press a button or every time I press on an image. ...
-2
votes
1answer
18 views

How to split a Excel file with excel Macro

I have a excel file and it contains 5000 record with header. Now i need to split the file to 5 different file with header row and 1000 records. These 5 files to in same path.
1
vote
0answers
22 views

Excel 2007: Unhelpful error message if VBA is not installed

My application generates macro-enabled Excel 2007 workbooks (.xlsm files). When a user who did not install VBA as part of their office installation opens such a workbook, they see an error message ...
1
vote
1answer
27 views

How to change a chart's orientation in Excel 2013?

Given the following data and chart: Why is the chart displayed from right to left and how do I change it to appear from left to right?
0
votes
0answers
40 views

Visual studio C# Excel object library

I have a program that runs perfectly on my PC, I'm using a Windows 8 with 2013 Office. My program is using Excel. Now the program has to function on a Win7/Office2010 combination. Can I just ...
0
votes
1answer
18 views

Microsoft Excel - Dynamically filter contents from one sheet to another and update as new content is entered

I've created an advanced filter to copy the filtered contents of one sheet to another sheet. But when new data is entered into the first sheet, the content in the second sheet is not updated unless I ...
-1
votes
1answer
22 views

How to create line chart in Excel with two series of ordinal/nominal data?

I have these two columns in Excel. Result Speed ------ ---- HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH HIGH MEDIUM HIGH HIGH HIGH HIGH HIGH HIGH ...
-1
votes
2answers
33 views

How to delete a specific word in Excel?

i need to ask if you there is something in excel where you can find a specific word in a cell and delete that but keep the other words or character in place. For example if I just want to delete dog ...
2
votes
1answer
37 views

How to make Excel chart axis start NOT at major unit?

Is it possible to have an Excel chart where the axis does NOT start at the major unit? See the example below, where I want the x-axis to start at the year 2007, but have major unit 5 years and show ...
0
votes
2answers
46 views

How to find rows with duplicate columns in Excel? [duplicate]

I have a large spreadsheet with possible duplicate rows. However I only care about matching some of the columns as highlighted in yellow below. So my question is: How can I search for duplicates in ...
0
votes
1answer
36 views

Compare two spreadsheets in a workbook, find the differences and record the differences on the first spreadsheet

I need a way to compare two spreadsheets in a workbook, find the differences, then write those differences on the spreadsheet in sequential order in the same column below the existing numbers. Sheet1 ...
1
vote
2answers
35 views

How can I create this column chart in Excel?

Well, I'm trying to create a column chart from this simple piece of data and I don't quite understand how the the chart tool is selecting the data and axises. Here is the data: ...
1
vote
2answers
46 views

Using Excel to make a grid in millimeters

Trying to figure out a way to make a grid in Excel that will print out in with spacing of mm's. Haven't figured out a way to do this yet though. I'm doing some work with Nanoblocks (which a single ...
0
votes
0answers
12 views

Microsoft Access - how to show document location in quick access toolbar?

In Excel 2010, I am able to show the location of a workbook by adding "Document Location" to my quick access toolbar (this is found under "commands not found in the ribbon). This is shown in Excel ...
1
vote
0answers
29 views

How to add custom columns to Pivot Table (similar to Grand Total)?

I have data which I pivot as Row Labels and Column Labels which gives me something like this: And what I would like to do is add columns like Grand Total (i.e. which applies to all columns as a ...
1
vote
1answer
27 views

is it possible to make comment appear faster in excel?

There are some comments in my Excel sheet Is it possible to make them appear faster when user hovers a mouse pointer over cell? Currently there is a small delay before the comment pop ups, I'd like ...
0
votes
1answer
36 views

How does Excel handle the h:mm:ss format?

I have the number 0.00082788917980126 which once converted to h:mm:ss format gives me 0:01:12, and I need to understand how as I need to perform similar formatting outside Excel, hence my question: ...
0
votes
1answer
32 views

Defined Name to give text or date value instead of numeric value

I had been trying out Define Name in Excel. I defined a name for a cell in which I would put a text or date value or I may leave it blank. But when I use this defined name in another cell, the second ...
0
votes
1answer
15 views

Nesting multiple IFERRORS with Index and Match

I feel like a dummy. I basically need a column that says - If column a2=0 then index and match column C, if that returns an error index and match column e, else index and match column a Current ...
1
vote
2answers
37 views

Align Secondary Axis Origin with Primary

I am interested in aligning my secondary axis such that it lines up exactly with my primary axis. To be more clear, I want the origins to both line up at 0 at the same place, each preserving their ...