**0**

votes

**0**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**10**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**8**answers

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

**6**answers

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

**3**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**4**answers

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**11**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**5**answers

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

**3**answers

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

**4**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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 ...