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 "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
0answers
696 views

Cannot access password protected Excel worksheet although I know the password

I had some changes to make to an Excel workbook that manipulates some other Excel files, formats the data appropriately and then uploads the data to a server. The VBA code for the macro is protected, ...
0
votes
2answers
9k views

How to parse specific string from an excel cell (No numbers in cell)?

I have the following data in cells 1 [Chelsea-QPR] 2 [Liverpool-Sunderland] 3 [NewcastleUtd-Everton] I want to separate the team names into two different cells. How can I do this?
1
vote
0answers
562 views

What format can I use in Excel to display both date and time in system formats

I need to display both date and time in system date and time formats. I know that [$-0xf800] means the system long date format and [$-0xf400] means the system time format, but [$-0xf800][$-0xf400] ...
0
votes
3answers
348 views

Microsoft excel formula on rounding up values

If a value is less than 200, then it should be rounded up to 200. How do you do this in Microsoft Excel?
0
votes
0answers
231 views

How to copy non table data into excel using data from web funcion?

I want to copy some data from say wikipedia, the data apears to be formatted as a table, however when I use the data from web function there is only one table to copy and that is the whole page, is ...
1
vote
1answer
2k views

How to calculate the area between two Excel charts?

I have two Excel charts: How do I calculate area between these?
2
votes
1answer
23k views

Create a form as a worksheet in Excel that adds records to another worksheet

I am trying to create a form in Excel for vehicle requests. What I want to happen is to create one worksheet that is a recreation of the current paper form, but have a clickable button that will ...
1
vote
1answer
67 views

Excel: Converting between data layouts

I have the situation as show below. There are groups of rows. Above each group is a small "header" describing a data field that all the rows in the group have in common. I want to create a pivot table ...
5
votes
2answers
7k views

Use the results of an Excel formula in another formula as a cell indexer

I have a basic formula: =(RANDBETWEEN(1,20)) which gives me a value, what I want to do is take that value (for the sake of argument '12') and use it to get another cell via another formula, i.e. ...
0
votes
1answer
1k views

How to convert currencies in Excel based on historical conversion rates?

I want to make a small program in Excel that allows the user to convert certain currencies (USD, Euro, AED, CHF and GBP) to Kuwaiti dinar. The user can set the amount, the currency and the month, and ...
0
votes
1answer
1k views

EXCEL populate a list of sunday's dates and ignore the sundays in an exception list

Hi i'm working on a sheet which i have to populate with sundays dates, and make sure that dates from an exception list don't be present in my final list Goal: is to have the list of dates of only ...
0
votes
3answers
6k views

How to highlight multiple rows based on column cell numbers?

I'd like to automatically highlight multiple rows based on the group of numbers in one column. So I would have a different row color for each unique family ID. Is there a way to do this without ...
0
votes
0answers
306 views

Computer freezes when editing links in Excel

I am editing links within my Excel file. These links point to another Excel file on a network drive. When I do so, often, Excel freezes for a period of time. Why's that and what can I do to prevent ...
5
votes
2answers
13k views

Coloring partial text within cell in Excel

In Excel there are several ways to dynamically color a full cell based off of its value, but is there any way to dynamically color only part of the cell based on its value? For example, say I am ...
3
votes
2answers
14k views

How to combine several records in a single letter using Word mail merge

I have a long Excel list with data in the following format: A, B, C -------- x, y, z1 x, y, z2 x, y, z3 I want to create a mail merge in Word 11 for Mac in the following style for each x, y , ...
0
votes
1answer
753 views

Excel - how to copy all colums in a row based on a condition

I'm new to macros and hope somebody can help Trying to make a report from a datasheet that meets some conditions. I need to fetch all the data (cells) in a row e.g. that meet the condition <1 in ...
2
votes
2answers
839 views

Get count of items based on certain dates

I need to solve this query: Column A contains an array of dates Column B contains daily entry of no / yes This formula returns the number of occurrences for no: =(COUNTIF(b1:b365,"no")) I need ...
0
votes
2answers
65 views

Excel files are opening with PowerPoint instead

When I first used a flash drive containing Excel files, Microsoft Excel was not installed on my computer. So, Windows 7 opened it with PowerPoint and now all the Excel files on my flash drive open ...
0
votes
1answer
496 views

Is it possible to Link to Excel File Based on Dynamic Mail Merge Field?

If I were to create an excel sheet with merge fields for a Mail Merge, and one of those fields were to be a file location, for example, can I then create a link in my Word document to a second Excel ...
2
votes
2answers
23k views

Calculating a duration in excel from date and time

I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
1
vote
0answers
42 views

Excel ran out of resources while attempting to calculate one or more formulas [duplicate]

Possible Duplicate: Excel ran out of resources while attempting to calculate one or more formulas I received the error message "Excel ran out of resources while attempting to calculate one ...
3
votes
4answers
26k views

Excel ran out of resources while attempting to calculate one or more formulas

I received the error message "Excel ran out of resources while attempting to calculate one or more formulas" on ONE of my computers (Out of 2). My worksheet contains: (Inside a single worksheet, not ...
0
votes
2answers
10k views

Sum of vlookup values on multiple sheets

Have 12 excel Sheets in a workbook for each month Jan-Dec. Each sheet contains Names and leaves marked for that month in the same row and sum value for each category of leave at the end of the table. ...
3
votes
3answers
229 views

Strange behavior of left arrow key in Excel 2010

When I press the left arrow to return to column A - it will not stop at column A but will continue to wrap around to the end (column XEP or something huge like that). How do I make it stop when it ...
1
vote
1answer
12k views

How to calculate a percentage of completed task in this spreadsheet?

I have the following spreadsheet. Basically Sam and Heather split out their assignment by task. When the task is complete, they mark it with Y in the Task Done column. At the bottom, in yellow, I ...
0
votes
1answer
3k views

#DIV/0! coming while evaluating correlation in MS-Excel

I am using MS-Excel for the first time to evaluate Correlation. To learn it I made two sequences of one as shown below: I understand I have selected range correctly (as can be seen in the ...
0
votes
1answer
159 views

Add multiple sheet value criteria based

I have an attendance register, needed to be maintained as monthwise separate sheets. Each sheet adds number of leaves taken under each heading by a person. This needs to be summarized on a single ...
0
votes
1answer
348 views

Mapping of child elements

I can't find one good way to solve this problem. I will try to sum the issue as best as I can: I use Hyperion Essbase Excel ad-in to navigate inside OLAP cubes. What I am trying to accomplish here is ...
0
votes
3answers
1k views

Any way to style the linked Excel Table in PowerPoint?

I have a linked table in my PPT (PowerPoint 2010), which is from a portion of an Excel 2010 worksheet. When I update the data in Excel, the table updates automatically in PPT, which works fine and as ...
1
vote
1answer
2k views

Excel Offset Function Returns #VALUE! Error When Combined with Row Function

Why does following Excel function return an error? The error occurs only when the reference that is returned is larger than 1 cell. In the formula, the returned reference is 1 row high and 2 rows ...
1
vote
1answer
2k views

Is it possible to add a data connection to an existing table in Excel?

I have a table in Excel which has a data connection to an Access database. When the data changes, I can click "Refresh" to re-query the data and update the table. However, Excel 2008 for Mac doesn't ...
3
votes
1answer
8k views

How to find hyperlinks in Excel 2010 and de-activate them?

When opening my Excel sheet using Excel 2010, I get a yellow bar at the top from Excel informing me that it has de-activated the automatic update of hyperlinks. To my best knowledge, I do not know ...
1
vote
3answers
7k views

EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]

Possible Duplicate: Excel conditional formatting to highlight entire row if one date is not equal to another date in that row I have the following rows... 1 AA 12 13 4 7 1 A ...
0
votes
2answers
724 views

How to get the date of a certain week's day?

I'm using Excel 2010. If I have TODAY() function on a cell (cell2), it gives me this: 12/26/2012. I want to get Monday's date based on cell2 date. In other words, in want this: 12/24/2012. How can I ...
3
votes
2answers
14k views

How to reference same cell in previous sheet in excel?

I know how to reference a cell in another sheet in Excel, but I'd like to know if there's some way to automate this process, such that if I duplicate a sheet, it will update its references to the ...
1
vote
2answers
7k views

How to copy an unformatted table into excel?

I want to copy the following table http://www.fifa.com/mm/document/classic/awards/01/36/25/40/ballondor_award_men_player_finalx.pdf into excel but when I do it doesn't format it as a table as the ...
3
votes
3answers
13k views

Batch convert XLS to XLSX

I have to work with an old application that can only export XLS files and I write programs in .Net using the EPPlus library that is only capable of reading XLSX files. What is the easiest way to ...
0
votes
1answer
3k views

Changing cell values based on another cell

Lets say that I have 3 parameters/cells: High (Cell A1) Medium (Cell A2) Low (Cell A3) the fixed values for these cells are 2, 2 ,2 how can I change the value of cellA1 based on the changes of ...
0
votes
2answers
1k views

ODBC Data Source Administrator Window Crashes

I would really appreciate some help with this. Running Windows 2008 R2 EE x64 SP1 with latest updates Office 2010 X64 (verified) with latest updates When I create a System DSN with an Excel ...
1
vote
1answer
267 views

Comparing different strings in consecutive cells highlighting on condition

I'm designing a shift roster and want to ensure person working in C shift (night shift) is not assigned shift A (morning shift) because it becomes a continous shift. This means, if value of cell ...
1
vote
1answer
832 views

Excel Formula For Grading

I am looking to create a formula in Excel to sum a number of grades on student assignments. Here is the relevant info: There were 11 assignments total, with grades entered into 11 columns (Columns ...
0
votes
3answers
10k views

How to copy/print/export Excel 2013 powerview sheet?

How can I copy Excel 2013 PowerView sheet to for example PowerPoint slide? Or if I try to export it to pdf-file I get a message in pdf: "Power View can only print one sheet at a time. Please switch ...
2
votes
3answers
3k views

Auto Updating an Excel Filter

I'm using excel 2010. I have had a look at other "auto-update" and from what I saw they wanted you to type some information in to make it "refresh" the auto-update. I have is two separate spread ...
1
vote
1answer
39k views

Find matching value in a row and return column name?

I have a sample price and I want to find the company that offers the lowest or an equal price to that sample price in the same row and put their name in the "Company Name" column. I tried to use IF to ...
2
votes
1answer
445 views

Formulas are not calculating after password protecting a sheet

Does anyone know why after password protecting an excel document, and by only ticking the 'select unlocked cells' option, the saved document will not automatically calculate the formulas once is ...
4
votes
2answers
474 views

How to plot this graph in Excel?

I have CSV with the following data There are 500 rows of this series. However, I need to plot whatever on A column as horizontal axis and B column [0..499] as vertical. If possible I would like to ...
1
vote
1answer
100 views

Querying variables in Excel

I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type. Here are some ...
7
votes
3answers
14k views

why does an Excel column formatted as number lose its leading zero when the column is formatted as text?

I have to export a spreadsheet to CSV. One of the columns is a zipcode with east coast zipcodes that have a leading zero. When I reformat that column as Text hoping to preserve the leading zero on ...
1
vote
1answer
164 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. ...
3
votes
2answers
321 views

Does AND work in Excel spreadsheet formulae using Ctrl-Shift-Enter?

I have an Excel (2010) cell with this formula: {=SUM(IF('Tasks'!$I:$I=$C4,'Tasks'!$F$2:$F$2000,0))} which works (the correct total is given). But when I enter another item to search for: ...