**0**

votes

**4**answers

233 views

### Create a 4-condition IF statement to display a certain value in a cell

I'm trying to do something which I hope will be reasonably straightforward in Microsoft Excel. I'm using 2010.
I have two columns called Username and Year Group.
Username takes the format of ...

**0**

votes

**2**answers

696 views

### Data distribution in Excel 2010

I have a column with close to a million rows, with values ranging from 25-140000 (approx.), although not every value in that range is present. How can I get a graph showing the distribution of the ...

**-2**

votes

**1**answer

239 views

### Adding extra information to a subtotal row by linking to another spreadsheet in excel

My task is to add another column to a backlog and link data from another worksheet to the backlog. The data should be linked to the corresponding subtotal row in the backlog by inputting the data to a ...

**0**

votes

**2**answers

4k views

### Filter data in sheets from a master sheet

I have a 'master sheet' with lots of furniture data in it, in column A there are the suppliers names. What I would like is to be able to have my master sheet with all the info and then sub sheets ...

**0**

votes

**1**answer

493 views

### Replace a batch of cells with scaled values

I have a set of values that I want to replace with 10x (or another factor) scaled ones.
Since I have to do it many times, is there any way to do it without calculating on separate cells and copying ...

**0**

votes

**1**answer

5k views

### Need an excel macro to produce a formatted text file

I am just learning how to make macros and I found a macro that nearly does what I need it to do, which is output a text file from Excel.
What I need it to do is output this in a .mhd format, which I ...

**-1**

votes

**1**answer

2k views

### Extract specific data from one sheet to another

I am trying to automate my company budget in Excel. The scenario is, On Sheet 1 I have all the account codes which refer to different account type, e.g.
500101
500102
500103
500105
700101
700102
...

**1**

vote

**3**answers

837 views

### Using a pre-existing function for a new row

I have an Excel document that contains X columns and N number of rows.
The very last column of a row performs a SUM of the first X-1 columns. The problem I have is, the user of this Excel document ...

**0**

votes

**2**answers

784 views

### Date axis with a partial year

I have a line chart with data spanning from February 2002 to today. At the moment, the date axis looks like this:
Is there a way to have the first date be Feb-02 (no change), but the next one be ...

**0**

votes

**1**answer

734 views

### Pivot Table grand total across columns

I'm using Excel 2010 and Power Pivot. I'm trying to calculate confidence and velocity for a development team. I'm extracting some information from our time and defect system each day and building a ...

**2**

votes

**3**answers

273 views

### What tool to use to create a chart like this one? [closed]

Which tool can you recommend to draw such a diagram:
I have tried Excel, but it is not really straight forward.

**0**

votes

**2**answers

5k views

### Microsoft Excel 2007 constantly calculating sheets

I believe this happening for two weeks now: Excel 2007 (on Windows XP) is acting funny on my computer; any medium sized sheet with some formulas in it takes a significant amount of time recalculating. ...

**0**

votes

**1**answer

1k views

### Excel autosave versioning

Is there any feature/option built into excel that allows the auto-saving of version documents.
I am developing a vba app at the moment (first one) and for those times that something breaks or there ...

**1**

vote

**0**answers

93 views

### Creating a script to make a CSV dump usable

So, let's say I have a raw CSV dump. And I want to make a spreadsheet/script to take said CSV dump, take a certain username, and the calls they made, and pipe those calls to a mathematical formula, to ...

**2**

votes

**2**answers

5k views

### Cells are not showing date as per Format in Excel 2010

In my excel sheet, I have selected date in Format Cells as 3/14/01 (which is M/DD/YY)
Some cells in DATE column are showing date in correct format like 5/31/12 (M/DD/YY), while some are showing it as ...

**0**

votes

**1**answer

114 views

### Extracting Excel-published tables from a PDF document

I'd like to copy Tables 1,2, and 3 found at the bottom of this PDF file:
http://www.cbo.gov/sites/default/files/cbofiles/attachments/03-13-Coverage%20Estimates.pdf
into Excel. I've tried Copy+Paste ...

**2**

votes

**1**answer

6k views

### How do you create a SQL query in Excel 2007 with a dynamic date range?

I am trying to create a reporting spreadsheet that can print reports for a given time period. The query below works, but when I try to use a ? parameter in place of the date, I get an error after ...

**0**

votes

**2**answers

4k views

### How can I set up conditional formatting to highlight a range only if all its cells are empty?

I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If ...

**0**

votes

**1**answer

717 views

### Move comments to new column in MS Excel

I have one column in a table where (almost) each cell in that column has a comment (red triangle), I would like to move all the comments into a new column.
Example of what I have:
Col.1
MIT ...

**1**

vote

**1**answer

2k views

### Create timestamp formula for Excel

The idea is simple, I'd like a function I could do something like =MOD_DATE_OF(A1:A4) and when any of the cells in such range is modified, the cell I assigned that formula gets the current date.
I ...

**1**

vote

**1**answer

229 views

### In Excel 2007 does the data from a formula referenced in another cell get used, or the formula itself?

Simple question and more than likely a simple answer.
I have a workbook with a few worksheets, one of which is a 'data' worksheet. This information is utilized on another worksheet 'main' to fill in ...

**7**

votes

**2**answers

38k views

### Why does my excel document have 960,000 empty rows?

I have an excel document, Office 2007, on a Windows 7 machine (if that part matters any, I'm not sure but just throwing it out there). It is a list of all employee phone numbers. If I need to generate ...

**0**

votes

**4**answers

4k views

### RegEx to Remove CRLF from CSV export from Excel

I exported an Excel File to CSV and do have a lot of multi-lines within.
I marked the beginning of each line with * and the end with ###.
*** some
text within
my cell to
export ###
Could someone ...

**1**

vote

**2**answers

910 views

### Excel formula depending on whether a cell is text or not

=IF(F46=0,I45-C46,I45-F46)
This works. But now I want to include the following as well: Let's say F46 is text – I want the cell value to be I45 (the previous cell value) but if it's not text I want ...

**0**

votes

**1**answer

679 views

### Excel Single column into rows, VBA script insight

Okay, so much similiar to the below link but mine is a bit different.
Paginate Rows into Columns in Excel
I have a lot of data in column A, I want to take every 14 to 15 rows and make them a new row ...

**3**

votes

**1**answer

312 views

### Paginate Rows into Columns in Excel

How would I 'paginate' every X row into a new column?
ORIGINAL LIST
Col A
-----
1
2
3
4
5
6
7
8
9
10
Is there a way to break after every third item? Turning the list into this:
PAGINATED LIST
Col ...

**0**

votes

**1**answer

990 views

### Excel 2010: if( , , “”) not treated the same as blank for pivot table group by date

I'm trying to group by date in an Excel 2010 pivot table.
The column with dates (i.e., the one want to group by), should be the latest date of 2 other columns if neither is null, or blank. i.e., ...

**0**

votes

**1**answer

1k views

### How do I fill in data using index, match, etc. in MS Excel?

I have data formatted like so.
1, 2, 3, 4, null, null, null
A, B, C, D, null, null, null
1, null, null, 4, 5, 6, 7
A, null, null, D, 8, 9, 10
I want to copy the data from row three into the ...

**-1**

votes

**2**answers

712 views

### How to calculate running totals of subsets of data in a table

I have 4 columns: Name, Week, Batch and Units Produced (Cols, A,B,C,D). In column E, I need to keep running totals based on name and week. When the week changes for the same person, restart the ...

**7**

votes

**4**answers

28k views

### Why is Excel removing leading leading zeros when displaying CSV data?

I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell 2A attempts to display "01" as a ...

**1**

vote

**2**answers

5k views

### Use Excel Table Column in ComboBox Input Range property

I asked this in StackOverflow and was redirected here. Apologies for redundancy.
I have an Excel worksheet with a combo box on Sheet1 that is populated via its Input Range property from a Dynamic ...

**1**

vote

**0**answers

479 views

### File in use when it's really not

I am running Windows 7 Professional 32 bit on a Server 2008 network. I am getting a weird issue with an excel document where I open it up one morning, update it, save and close, the next morning I ...

**1**

vote

**1**answer

10k views

### Is there a macro to split the contents of an Excel spreadsheet into separate spreadsheets?

I know there are similar questions out there but I don't think they are quite the same.
I have an excel spreadsheet with the following headings-
First name -- Surname -- Host Trust -- Contact ...

**0**

votes

**3**answers

1k views

### How can I compare Excel serial dates WITHOUT converting to mm/dd/yy type dates?

I have a table that contains a number of values representing Excel serial dates. After a number of unsuccessful attempts to compare fields, my current approach is to do comparisons between serial ...

**1**

vote

**1**answer

138 views

### Error message when trying to retrieve a value from a range using VLOOKUP

I've got an excel spreadsheet where I would normally use a VLOOKUP.
In this case I need to find the ID of the record when comparing email addresses, so the email address is the unique id here.
For ...

**2**

votes

**3**answers

4k views

### How do I `SUM` by multiple columns in Excel

I have a comma delimited file that includes two columns date/time (which imports as Excel's mm/dd/yyyy hh:mm custom format) and status of 1 or 0. The status represents a piece of equipment either ...

**0**

votes

**4**answers

622 views

### Bloated Excel file with negligible data

I have a workbook, with three sheets and only a couple rows in one sheet and around 100 rows in another sheet (with only three columns) that is about 50MB.
I used Ctrl+Shift+Down to enter formulae ...

**18**

votes

**10**answers

65k views

### How do I force excel (and other office products) to stop opening files in the same application? [duplicate]

Whenever I "double click" on an Excel file and another Excel file is open, the newly opened file automatically opens in the same application window as the previously opened Excel file. This isn't ...

**0**

votes

**2**answers

129 views

### excel drop-down data

I'm using list feature to implement drop-down in excel.
Sheet2!$A$2:$A$101
Is there a way to replace it with something like
Sheet2!$A$2:TILL_THE_END_UNTIL IT SEES A BLANK ROW
instead of ...

**-1**

votes

**1**answer

76 views

### Is there a tool to get data from a pie chart instead of the other way around?

I'm looking for a tool that helps me creating an investment portfolio. I'd like to decide the percentages first, and then the tool would output quantities. Also, percentages should be hierarchical. ...

**0**

votes

**2**answers

190 views

### Create Excel pie chart from choice placement

I have a table like the following :
Choice 1 Choice 2 Choice 3
Person A 3 2 1
Person B 1 2 3
...

**2**

votes

**2**answers

3k views

### Extract values from a range that are missing from another

I've got two columns in Excel, "ROSTER" and "PRESENT", shown below:
Is there a formula to achieve the "NOT HERE" column? I tried using VLOOKUP() and http://superuser.com/a/289653/135912 to no avail ...

**2**

votes

**3**answers

440 views

### How to sum up numbers conditionally in Excel? [duplicate]

Possible Duplicate:
Sum Values in One Range Based on Criteria in Another
I have the following Excel document, which tracks hours needed to implement various tasks by the development ...

**0**

votes

**1**answer

907 views

### Function to intelligently concatenate/combine tables in Excel

Which function in Excel will intelligently combine tables using a common column as an index?
For example: http://s10.postimage.org/8dwh1agfd/superuser.png

**1**

vote

**1**answer

115 views

### Find column where sum is meeting condition?

A have a sheet with resources and week together with availabilty per week (hours). Like this.
Resource 1225 1226 1227 ... 1252
.NET 30 30 15 ... 30
Java 40 40 40 ... 40
In ...

**4**

votes

**2**answers

11k views

### Excel - define a formula in one cell to be used in other cells with different inputs like a function

I use excel 2010.
I want to use a formula defined in one cell as if it was a user-defined function.
Example:
In A1 I put something like (I know it's not a real syntax):
= 3 * Input + 15
And then ...

**9**

votes

**4**answers

83k views

### excel - how to enter formula for entire column

I know if I select the entire column and then enter the formula in first column and then press ctrl+enter, it would be taken care of. However, my first row is title row. How else should I do it?

**4**

votes

**5**answers

65k views

### Excel: convert a column with hyperlinks to just display the links

In Excel, I have a column of links that display text instead of the actual link.
I actually need the links, is there a way to bulk convert the entire column so that the links are exposed? Otherwise I ...

**2**

votes

**1**answer

1k views

### How do I make my Mac Air running Lion recognize Chinese characters in Excel?

I open an Excel document with Chinese characters and see the following.
How do I make my Mac Air running Lion recognize Chinese characters in Excel?

**0**

votes

**1**answer

75 views

### Excel look-up column data

I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from
HMIP LDU
1 Leeds
2 Leeds
3 Leeds
4 Leeds
5 Wakefield
...