**1**

vote

**0**answers

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

**2**answers

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

**0**answers

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

**3**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**0**answers

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**4**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**3**answers

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

**2**answers

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

**2**answers

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

**2**answers

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

**3**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**3**answers

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

**3**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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:
...