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)

1
vote
2answers
723 views

Windows 7 Excel 2010 annoying personal.xlsb message

I'm running Windows 7. Each time I run Excel I get this message popping up. Excel cannot open the file '~$PERSONAL.XSLB' because the file format or file extension is not valid. Verify that the ...
1
vote
1answer
4k views

How do I copy hyperlink only (and not text) to another cell? [duplicate]

I have a spreadsheet where column A displays names. There are a few hundred names and each has a different hyperlink (which links to that person's web page). I want to transfer those hyperlinks across ...
1
vote
2answers
12k views

Excel scatter plot with multiple series from 1 table

Say I have a table as follows: Label | X | Y | A | 1 | 1 | B | 2 | 2 | B | 3 | 2 | A | 4 | 3 | C | 5 | 4 | A | 4 | 3 | C | 2 | 1 | How ...
1
vote
1answer
39 views

Formula that looks at value in a cell and depending on what the value is

I'm using Excel 2010 I have a number in cell A1. In Cell B1 i need a formula that says if the number in cell A1 is 25 then put 'account1', if the number in cell A1 is 58 then put 'account2', if the ...
1
vote
1answer
733 views

How do I create a dynamically-growing graph which ignores empty tail cells?

I have a table on an Excel 2010 Worksheet 'Consolidated Data' where: Column A is filled with arbitrary dates sorted by increasing age Column F has numeric data relevant to this question Row 1 is the ...
1
vote
3answers
279 views

Assign triggered code to multiple images - Excel VBA [duplicate]

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 ...
1
vote
3answers
146 views

Excel combine rows dollar amount with matching row values?

I've ran into a problem with Excel, I have the below table Basically, I'm trying to figure out how to make all rows that have the same product key combine, except calculating the dollar amount for ...
1
vote
2answers
1k views

Find most recent date for ID with multiple records in Excel sheet

On Sheet1 in column A, I have a work order number, and on Sheet2 in column A, I have a list of invoices -- each referencing one of the work order numbers on Sheet1. There are multiple invoices for ...
1
vote
2answers
250 views

How do I refer to a cell in another worksheet with a long name?

As explained in this other Answer, SheetName!A1 = cell A1 in the worksheet called "SheetName" (without quotations). Say the name for my worksheet is very long. Without shortening "SheetName" and ...
1
vote
0answers
462 views

How do I tell MS Excel to use the non-standard decimal separator in graphs and charts?

MS Excel 2010, using US English as default language. I have a document that needs to use the interpunct (·) as the decimal separator. I can go to File -> Options -> Advanced -> Decimal separator and ...
1
vote
2answers
77 views

Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so What I am looking for is a formula that will search Product and return the latest date. e.g., A B ...
1
vote
2answers
7k views

Automatic copy rows with matched column to other worksheet

Now I have a worksheet named sheet1 like the left side of image I want to automatic copy all rows of sheet1 that have the column C = NO to worksheet sheet2 like the right side of image. And each ...
1
vote
1answer
118 views

Excel reference - connecting a list to a database

I am trying to create a database. I have 2 columns, if I enter a number in the first column, the matching name should appear in the second column automatically. The list of numbers and names is on a ...
1
vote
1answer
2k views

Why does Excel treat some dates differently than others?

I have a CSV file that contains strings meant to be interpreted as dates with minutes, seconds and miliseconds. In particular entries look like this: "07/31/2013 23:59:32.864",otherdata,moredata ...
1
vote
0answers
152 views

Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003. We are now migrating to Excel 2010, and have encountered the following problem. When the workbook is opened in 2010 ...
1
vote
0answers
555 views

Opening an Excel 2003 workbook in Excel 2010 32-bit causes bogus circular reference and crashes

We have a workbook that we have been using daily for many years in Excel 2003. We are now migrating to Excel 2010, and have encountered the following problem. When the workbook is opened in 2010 ...
1
vote
0answers
650 views

Why recovered .xls and .doc files show as symbols?

I formatted an NTFS drive (and re-installed windows) which had some important .doc and .xls files, I used 2 recovery software and both recovered my files but seem to be corrupt, when opened they ...
1
vote
2answers
113 views

Transform numbers into hyperlinks - Excel

I try copy different links from Firefox into Excel but links-numbers are formatted like text and not like hyperlinks. Paste links from Firefox into Word - numbers-links are recognized: Paste links ...
1
vote
1answer
1k views

How to get or copy a background image in Excel?

I have an Excel document, and I need to extract the background image from a sheet in order to put it in other sheets of this document. How can I do that? I would also like to extract it in order to ...
1
vote
2answers
7k views

Excel: if duplicate cell value found in another column then highlight green

Can someone help me, I'm not sure what formula to use. I have highlighted the cell in the picture to show an example of what I mean. What I want to do is highlight the cell in column A where the ...
1
vote
1answer
4k views

Excel 2007: Intermittent 0xc0000005 crashes

Hello there SuperUser Hive Mind. We are having an issue at the office I work. One of our users who has a workflow which consists mostly of Excel documents with dynamic formatting and macros which she ...
1
vote
1answer
601 views

Excel formula PERCENTILE and how it works with ranges i.e A:A

Say I have the Excel formula PERCENTILE(A:A,0.01). I imagine that this range equals A1:A65536 (or whatever is max). But would that mean that in its calculation of percentile it has a list of 65536 ...
1
vote
3answers
3k views

How to create an excel report by month

I have a list of data in excel with a date column. When I want to generate a report I typically create a new column in the data tab and type in a code in text format like "April08", then I put a ...
1
vote
2answers
161 views

How to display a specific formula value as a 0

I am using the DAYS360 formula to count how many days since last activity from a predefined date =DAYS360($R15,$X$1) The R Column reports on last activity date, whilst the the X1 cell contains the ...
1
vote
2answers
4k views

How does Excel's VLOOKUP handle multi-word lookup values?

I have a worksheet that's returning unexpected VLOOKUP results, and I'm trying to narrow down the issue. I've run into a question I can't answer in my search for the solution. Consider: I have a ...
1
vote
1answer
82 views

Header on Excel 2010

I'm using Excel 2010. I need to add a special header. It's the one which you can scroll down on the Excel data and the header is always visible on top. And you can see in it in Normal View. ...
1
vote
1answer
671 views

Automatically select last row in a set in Excel

In Excel 2003, I am trying to keep track of some petty cash, and have it set up with the denomination along the top row, along with a sub total and difference column. I want a small section that shows ...
1
vote
1answer
2k views

Lines over data in Excel 2007 Scatter Graph

I have some data that needs plotting in a scatter graph in Excel 2007. However, I need another line (for some arbitrary function - e.g. using trendline will not work) that is represented by a second ...
1
vote
3answers
11k views

In Excel 2010 why can't I change the date format?

The original date is in the following format: 14/Nov/201110:53:44 I need it in this form: 14.11.2011 10:53:44 When I choose Number -> Custom -> d.m.yyyy h:mm -> OK , nothing changes. ...
1
vote
1answer
265 views

what would be the custom format code to display percents as if it were multiple by 1000

or how can this be solved by having the input and output on the same row. custom format code solved this for numbers -- Modify value of a cell using the old value as part of the new one? quotes: ...
1
vote
3answers
3k views

how to extract data from an image graph

I'm looking to get that from a graph. but problem is that graph is in image form. Now I want to extract data in excel from that graph. how can i do it? I'm using office 2003.
1
vote
3answers
10k views

How to add up all values in column F that has the same value in column A?

i.e. if I'd like to sum the total score of a student from a sheet like this: Student ID | Score 123456 | 12 654789 | 14 585822 | 5 982531 | 22 982531 | 32 123456 | ...
1
vote
1answer
1k views

Remove URL Parameter in Excel

I have a URL of the following form: http://www.example.com/page.html?param1=asdf&param2=asdfg&param3=asdfgh I want to extract the value of param2 or 3 from the URL as well as remove that ...
1
vote
1answer
8k views

Compare cells in two different spreadsheets and extract data from one an place it in the other if match found

I need to find a way to compare two spreadsheets and if there is a match on specific cells, pull data from one sheet to another. Say the two spreadsheets contain a value that identifies a piece of ...
1
vote
6answers
12k views

duplicating a row in excel

i have a large financial spreadsheet with a ton of formulae. i'd like to duplicate a row such that it retains the same formula and coordinates as the source row (basically duplicate a summary row and ...
1
vote
2answers
582 views

Searching for content in a large number of Excel files

I have 2500 Excel files. I need to output all rows which contain a certain string in a certain column. How can I do this? What if the certain string is not in a fixed column, but could be in any ...
1
vote
1answer
120 views

Changing cell color based on its contents

I have a list of car dealerships. What I'd like to do is change the color of the cell based on what type of dealership it is. So, for example, if I have the cells: ABC Ford DEF Chevrolet GHI Honda ...
1
vote
1answer
7k views

Excel, merge two sheets with one column as key

Let me start by saying I exclusively use Excel to view things and that's where my experience ends. I have two sheets with some common data, and most importantly, a column in each that has the same ...
1
vote
2answers
1k views

How to reference or vlookup a list of values based on a comma separated list of column references within a cell in excel?

I want to do a vlookup (or similar) against a column which is a list of values. This works fine for looking up a value from a single row, but I want to be able to look up multiple rows, sum the ...
1
vote
2answers
185 views

Group a number of Excel columns into rows

Currently, I am working on a column with the content for teacher's comment. I would like to delimit it by the space or comma or punctuation marks between words inside the content. At the same time, ...
1
vote
4answers
4k views

Excel cannot open an xlsx file

Excel cannot open a file called file.xlsx. The error states this is because the file format or file extension is not valid, and I should verify that the file has not been corrupted and that the file ...
1
vote
2answers
1k views

Excel, group a number of rows into columns

Hi I have data that has been pasted in the form of 616 rows in 1 column. is there anyway to separate all these rows into columns knowing that every 9th row should be the beginning of a new row, is ...
1
vote
1answer
4k views

Prevent Excel 2010 user from pasting formatting into cell

Is there a way to lock a cell so that a user can copy/paste a value into it, but not copy formatting to it? Locking the worksheet doesn't prevent the user from changing the formatting of the cell by ...
1
vote
4answers
11k views

How can I avoid the clipboard message box when copying large amounts of data in Excel?

I have a macro that is copying 4 sheets from one workbook to a new workbook and saving it down with another name. Unfortunately the message box asking me whether I would like to make this large ...
1
vote
1answer
2k views

How to use multiple criteria with COUNTIF?

INPUT: This is the format of the OUTPUT desired: OUTPUT for example INPUT: The problem is, I don't know how to use COUNTIF with several criteria. The "dream function" [that doesn't work] ...
1
vote
3answers
5k views

Lookups targeting merged cells - only returning value for first row

I have a master worksheet which contains data that I wish to link to another 'summary' sheet using a lookup. However, some of the cells whose data I wish to include in the summary sheet are merged ...
1
vote
3answers
4k views

How can I count unique comma-separated values in Excel 2010

I need to build a formula to walk a column of comma-separated values and count the number of unique values seen. I am using Excel 2010. I have a screenshot of some example data... The output of ...
1
vote
1answer
421 views

How exactly do I create “Dynamic Named Ranges”?

I'm trying to create a "Dynamic Named Range" in Excel so I can populate an X/Y values table inside of it in Java. I've seen tutorials, but I still don't get it. I know I have to use the =OFFSET() ...
1
vote
1answer
623 views

How to enter formulas in Excel in other locales (with different decimal separators)?

I'm getting a strange error in Excel where I cannot enter formulas: =ROUND(1.5,0) gives an error: The formula you typed contains an error I presume it has something to do with the (red ...
1
vote
2answers
22k 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 ...