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 "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
2k views

Stretch an Excel table in PowerPoint over multiple slides? [duplicate]

I work in a business where most people run on PowerPoint and wouldn't know what to do with an Excel sheet if it bit them. I need to regularly update a spreadsheet and put it into PowerPoint, but it ...
2
votes
1answer
200 views

Macro Help: Finding a replacement for Cut and Delete for Speed

I’m looking for a way around using the commands .delete .cut In my excel macros. I’m finding that these processes greatly slow down the procedure (by up to 20 min) for the more data it has to cut ...
2
votes
1answer
7k views

Make COUNTIFS count duplicate values only once

I've got all this data on test runs: controller start end start ts end ts 1 1:13 1:15 1:00 1:30 1 2:08 2:25 2:00 2:30 4 4:02 4:16 4:00 ...
0
votes
0answers
132 views

Excel 2010 slow or hangs when doesn't have focus [duplicate]

Possible Duplicate: How do you keep Microsoft Excel running at full speed even when it does not have the window focus? Running Windows 7 with Office 2010. We are seeing a huge slowdown (4x ...
2
votes
2answers
2k views

How to format an excel cell as a year, month?

If I have the following value: 18 How can I get Excel to show this as 1 year, 6 months or something similar?
0
votes
1answer
1k views

How do I design a form in Word that queries and inserts data from an Excel table?

I put together several document submittals per day, and for the coversheet I manually copy/paste from an Excel table into Word for the document list. Also, each coversheet has a header with the ...
2
votes
1answer
5k views

how can I convert HEX numbers into Text in Excel 2007

I have one column (A) with decimal numbers A second column currently has this function: =DEC2HEX(A1) The second column currently shows the hex equivalent of the decimal number e.g. 14=E I wish the ...
0
votes
1answer
1k views

Delete duplicate rows between worksheets

I have two sheets with a basic structure: Sheet(A) and Sheet(B). Sheet(B) is a subset from sheet(A) that needs to be removed from Sheet(A). How can this be done in Excel 2007?
1
vote
1answer
340 views

How to sum the multiplications of rows, being the multiplier variable in a spreadsheet

I have this spreadsheet: I want to calculate the total income, but since the different rows are in different currencies the conversion must be done first. The currency values are mapped to codes in ...
0
votes
3answers
3k views

How can I make a graph with vertical exaggeration?

Is it possible to make a graph with vertical exaggeration? I am trying to plot several graphs (normalized), but in the Y scale I only can see some little bumps.
1
vote
2answers
569 views

Excel: Remove lines with duplicates in column B, based on data in Column A

I need to find duplicates in Column B; and then delete the entire line if the the value in Column A is the number 4. There are lines that need to be kept and have "4" in Column A. A B 1, John 4, ...
0
votes
1answer
1k views

Excel Import Dialog that prompts for location of file

Is it possible to have an Excel Macro stop and prompt for the location of file to be imported? I've created several macros for importing text files but the imported file must always exist in the ...
0
votes
2answers
6k views

Insert rows into worksheet from another workbook?

I have two workbooks, say: workbook_a.xlsx and workbook_b.xlsx and both contain different worksheets. Two of those worksheets are already linked by a couple of VLOOKUP formulas using a unique key ...
9
votes
2answers
48k views

How do I use a Private Sub in Excel?

I'm want to use the Private Sub functions provided here. Usually a put VBA code in the Visual Basic Editor, I then close the editor and I run the code using "Run this Macro" on the Developer tab. But ...
0
votes
2answers
882 views

Get External Data with carriage returns

I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option. The file has a text qualifier and is pipe delimited. Here is ...
0
votes
2answers
1k views

How can I sum a range in Excel from the indicies of the start- and end-points?

I have a spreadsheet that contains a list of data points over time, along with some time values that denote events. I want to sum all the data points between each of the event values. My spreadsheet ...
3
votes
10answers
142k views

Excel isn't calculating the SUM of cells [duplicate]

I am trying to use a very simple formula which is =SUM(B9:B11). However the cell doesn't compute for some reason. I've used Excel for years and have never had this problem. Any idea why it may be ...
7
votes
2answers
6k views

Importing CSV into Excel with commas in quoted fields

I have a CSV file that contains a text field that can have commas in it. When importing it into Excel, it's picking up these commas as field separators. I have the field in quotes, and I've tried ...
5
votes
2answers
17k views

Convert unicode to corresponding text in Excel spreadsheet

I use "Char" to convert an ascii number to a character. What do I use to convert a unicode number to a character? I'm building a Hebrew conversion chart. For example, 1489 is the letter "BET". I ...
3
votes
2answers
1k views

Chart data by month

I've the following data in an excel spreadsheet: Date (dd/mm/yyyy) Value ----------------- --------- 01/04/2011 123.45 03/04/2011 7234.25 16/05/2011 80.00 ...
10
votes
8answers
37k views

How to remove white space from a number

I have a column of number with white spaces in them. Like this: "32 445 423". How do I get rid of all the white space to get excel to treat it as numbers rather than strings? EDIT: Let me fill in ...
58
votes
6answers
225k views

Cells not updating automatically

I have a formula in a cell which counts the values in 2 other cells. Normally, after entering in the values in these 2 other cells, the formula cell updates automatically when Enter is pressed or when ...
2
votes
3answers
24k views

How to count number of repeat occurrences

I have an Excel Spreadsheet that looks more or less like this: +------------+-----------+ | First Name | Last Name | +------------+-----------+ | John | Paul | | Joe | Jones | | ...
1
vote
2answers
621 views

Excel IF statement

I am trying to look at column E and if it is >0 put a 1 UNLESS column D has a value. If column D has a value, I would like to copy the contents of column D. I was thinking the following formula would ...
2
votes
1answer
2k views

How do I disable multithreaded calculation in Excel 2010 - as a permanent setting (without needing to set it on a worksheet)

I need to be able to have excel 2010 open (in windows 7 if it makes a difference) and have this setting defaulted to off. I've tried unchecking the box and closing excel, saving the setting on the ...
8
votes
2answers
43k views

Excel: How to display superscript text as data series on chart?

I have a line chart in Excel 2007 that is created from data in the worksheet. It has several series whose titles are displayed in the chart on the right side. The names of the series are of the form ...
2
votes
4answers
14k views

How do you save an Excel document as a Word document?

I was hoping someone could tell me how to save a Microsoft Office Excel document to the Microsoft Office Word document format?
2
votes
3answers
18k views

How do I line up two sets of data in Excel?

If I've got two sets of data, how can I line them up in Excel 2007? For example, if one set of data has Position Occurrences 8 3 11 1 17 ...
0
votes
3answers
1k views

How to get Excel 2003 to treat long string of numbers as text?

My web application exports data in tab delimited format. One of the column contains long strings of numbers that are IDs. Some of these number strings contain leading zeros. Is there anyway to get ...
3
votes
1answer
2k views

Pivoting concurrent start and end times into timeslots with Excel 2010 PivotTable

I've got a table of processes and their respective start and end times (calculated from the start time and duration), listed by the process ID: Run ID Duration Start Time End Time 200878 464 ...
2
votes
1answer
4k views

How do you apply a function to all values in selected cells?

I was entering timesheet data (in minutes) into an Excel spreadsheet. Then the requirements changed - the data actually needs to be in hours. Is there a way to divide all the cells by 60 in place ...
1
vote
2answers
358 views

Desktop software for data analysis, like Business Objects “Lite”

My data set is sourced from ~100k users, with a few million records scattered over a dozen tables. Just too big for Excel, but not quite a data warehouse. It's sourced from a web-sites user base and ...
1
vote
1answer
6k views

Windows 7 can't open Excel 2010 .xlsm files?

I just reinstalled Windows 7. When I installed Office 2010 I deselected some components to save disk space. Now, I can't open xlsm files. I would like to know which components in the Office ...
4
votes
2answers
25k views

Finding Data Tables in Excel

I have inherited a spreadsheet which contains several data tables. I know this because when I recalculate the spreadsheet takes time to recalculate the tables, and shows this in the recalculation ...
1
vote
2answers
1k views

Excel 2003: Disable Drag and Drop on all sheets without VBA

Is there any way to disable drag and drop of cells on all sheets without a script. I know you can do it globally, there is a setting in the Excel program that disables it locally on your machine. ...
3
votes
1answer
106 views

Excel find cells by formatting?

The countif function has a criteria argument – how do I specify a criteria based on the formatting of cells? I have a list of math homework questions containing per-page the questions numbers (e.g. ...
39
votes
11answers
86k views

How can I set Excel to always import all columns of CSV files as Text?

Though I try to avoid it, I occasionally have to open a CSV file in Excel. When I do, it formats columns containing numbers, which makes them useless for my purposes. As far as I can tell, the only ...
0
votes
2answers
7k views

Checking if any cell in a column of strings on one worksheet is contained in a column of strings in another worksheet

I have a column of strings in an Excel worksheet. I'm looking for a way to write a worksheet function (not VBA) that will allow me to tell, for each cell, if the value of the cell is contained in a ...
2
votes
3answers
141 views

Finding the number of specific characters inside a formula

I'm trying to find the number of of +'s in a formula inside a single cell in excel. If it were a normal cell with text inside, this would be quite easy. But due to the restrictions of the file I'm ...
1
vote
1answer
833 views

Excel formula using relative row and constant value

I am using the following Excel formula to get the relative row number for a calculation. =$A9*(C3) Cell C3 contains a constant value, so I always want to use that value, regardless of the row. When ...
6
votes
5answers
11k views

How to return everything between two characters in Excel?

I'm a programmer with lots of languages, but somehow I've never learned Excel macro or formula language. I'm sure there must be a simple way to do this, but I'm stumped. I have a column of file names ...
0
votes
3answers
171 views

Excel: better ways to express this as a formula

X is an integer > 0 For x = 0, return 0; for all other x, return 1 Solutions I have considered: IF (whatever), obviously. Want to avoid it if possible, just because nested/lengthy formulas using ...
6
votes
4answers
29k views

How can I merge hundreds of Excel spreadsheet files?

I have hundreds of excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 all singing and dancing file which must have the same format ...
0
votes
2answers
2k views

Multiple IF Then Function

I know this shouldn't be this difficult, but what I am looking to do is I want a total in A5, based on a running total in A1 through A4. For example, if A4 is blank then input A5=A3, if A3 is ...
0
votes
1answer
752 views

Excel formula to get response time

I have a table in Excel where I save an input time of a query and the output time of the query - i.e. when I receive it and when I handle it. I want to calculate the my response time. What is the ...
0
votes
2answers
455 views

Excel Find and Replace regexp

I have a whole list of entries in two columns say ColA as dn: uid=HM_SERVICE1,cn=users,dc=somedomain,dc=main,dc=org objectclass: inetorgperson objectclass: top objectclass: person objectclass: ...
7
votes
2answers
7k views

Export of a custom table style in MS Excel

How to export a custom table style in MS Excel 2007/2010? I know how to export a custom chart, but I can't see how to export a custom table style.
0
votes
2answers
933 views

Summing of total with dynamics rows coming external datasource

I am using Excel 2010 and retrieving data from SQL analysis service. When I refresh the data from Excel, the rows all refresh as they are bound to an external datasource. I am adding a separate ...
1
vote
2answers
31k views

Excel 2007: How to replace part of formula with another formula?

I need to replace the $D49 with SERROR(VLOOKUP($B49 & " Total",Flt_S2D1,$Z$47,0)),0,VLOOKUP($B49 & " Total",Flt_S2D1,$Z$47,0))** in below formula. =IFERROR(IF($Z$38="CBO ...
0
votes
3answers
2k views

Selecting all data in Excel column regardless of size

I have a repetitive process that I must do in Excel for test data collected. I have to do this process for every data point I collect. I collect over 200 data points each test. My data is auto ...