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
1answer
57 views

Lining up sets of data in Excel (both with unique keys)

A related question asks how to line up two sets of data in Excel. I am struggling to figure out how to do this when you have values in both lists which don't exist in the other list. Ie: how would ...
1
vote
1answer
217 views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
1
vote
0answers
118 views

How to calculate average daily sales for each month in a pivot table

I need to calculate the averages I have in a month. What I'm expecting is to calculate 936, 184, 943, and 230 and get an average of 573. However, when Excel calculates these values in a pivot ...
1
vote
2answers
47 views

Excel Convert the correct Date type

I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP My formula is =Text(A2, "mmm") which is the correct formula, ...
1
vote
1answer
176 views

Using the with cURL command-line tool on Mac, What can I do to this script to ask it to fetch stock data which comes back WITHOUT commas?

cd documents/quoteUpdate while true do curl -o quotes.txt -s "http://download.finance.yahoo.com/d/quotes.csv?s=goog,aapl&f=sl1c1p2pt1" echo UPDATED: date sleep 10 done
1
vote
2answers
159 views

Chart macro displaying incorrect labels from non-sequential visible rows on filtered worksheet

This macro displays text labels from the source worksheet when double-clicking a dot on a scatterplot chart. The chart is updated when the source worksheet is filtered on any of several columns. The ...
1
vote
1answer
1k views

Efficient removal of duplicate records across multiple Excel sheets

I have a workbook with 2 sheets. Sheet 1 has 3 columns (1A, 1B and 1C) and sheet 2 has 2 columns (2A and 2B). Now I need to delete rows from sheet 1 if 1A and 1B match any row in sheet 2 (i.e. 1A=2A ...
1
vote
2answers
128 views

Hiding all but the selected rows of data

I am unable to send any pictures, The data contains 98 column headings, with the first column being unique identifiers, and 1000 rows of items. I receive commentary on specific items throughout the ...
1
vote
1answer
419 views

No Startup folder in Microsoft Office for Mac 2011

I'm trying to save a new default worksheet in Excel for Mac 2011. Instructions say to save it in the Startup folder at this location: /Applications/Microsoft Office 2011/Office/Startup/Excel There ...
1
vote
1answer
105 views

How to combine data from two sheets and conditionally format rows based on sheet of origin

I have 3 sheets in Excel "Open", "New", "Combine" "Open" Sheet (Old list) Ticket ID | Priority | Department | Status 36009 | 1 | Finance | 01-Open 34781 ...
1
vote
1answer
261 views

Excel automatically adding an extra row with formulas for the inputed number of years

I am looking to build a model. I would like to have an input page where you input the range of years you would like to cover. Depending on the inputted number of years, I want a table (on a different ...
1
vote
1answer
49 views

How to have a cell that displays the cumulative value of all values entered in another cell?

I want to have a cell on my spreadsheet that updates in a cumulative manner, in response to values being changed in another cell. What would the code for this cell be? For example the original value ...
1
vote
1answer
602 views

Excel: How to extract group of the same rows and their values into columns?

How can I extract the second table from the first one? I need to extract those titles that have exactly three costs (in the following example: f1 and f3). I tried using pivot tables but could not ...
1
vote
1answer
273 views

How do I debug Excel / OpenOffice / LibreOffice macros - getting started

How do I get started with debugging VBA macros? This is to help to locate faults and mistakes within the code and the data it handles.
1
vote
2answers
762 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
1answer
42 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
787 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
300 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
185 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
3answers
14k views

How to remove duplicate row based on some columns

I have a excel sheet which contains duplicate I want to remove a row if its A C D E F columns are same (Ignore B while calculating duplicates but remove it while removing a row) At the moment it ...
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
270 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
480 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
79 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
8k 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
126 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
164 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
565 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
671 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
624 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
167 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
89 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
703 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
268 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
11k 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
13k 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
610 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 ...