A spreadsheet application by Microsoft. Use this tag along with [vba] if your question involves programming Excel in VBA, and with [worksheet-function] if it involves an Excel formula or worksheet function.

learn more… | top users | synonyms (2)

0
votes
4answers
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
2answers
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
3answers
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
2answers
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
1answer
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
3answers
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
2answers
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
1answer
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
0answers
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
2answers
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
1answer
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
1answer
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
2answers
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
1answer
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
1answer
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
1answer
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
2answers
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
4answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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
2answers
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
4answers
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
2answers
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
0answers
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
1answer
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
3answers
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
1answer
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
3answers
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
4answers
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
10answers
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
2answers
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
1answer
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
2answers
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
2answers
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
3answers
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
1answer
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
1answer
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
2answers
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
4answers
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
5answers
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
1answer
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
1answer
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 ...