The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**0**answers

2 views

### Formula that will get more than 1 row of data

I am using this formula =VLOOKUP(LARGE(A2:A63,1),A1:M63,11,FALSE) it is working well it recognizes the date in column A and gives me the % in column K that i want, the problem is this formula only ...

**0**

votes

**0**answers

24 views

### How to show the days of a month in a Excel bar chart

with the usage of http://www.smartsheet.com/blog/gantt-chart-excel I created the following Gantt chart
As you can see on the top there are some dates 3sept, 8sept etc. My question is if there is ...

**0**

votes

**0**answers

21 views

### Vertical line excel chart

How is possible to draw in MS Excel (starting from 2003) charts like this
Seems incredible that basic things like this be hard to do in Excel
I read this article but it involves other 2 helper ...

**-1**

votes

**1**answer

34 views

### Formula issue Microsoft Excel

I need help urgently for a work problem.
So basically, the summation of opening stock and production give total stock.
While closing stock is ((opening stock+production)-sale)) and stock cover is ...

**0**

votes

**0**answers

18 views

### Excel recover read-only edited file

I needed to edit a file which was sent to me as an attachment in email.
I opened Outlook and then opened the attachment in Excel. The Excel window appeared probably in read-only mode which I didn't ...

**0**

votes

**1**answer

16 views

### Convert string Jan to January, Feb to February, Mar to March etc

I would like to be able to convert the string value Jan to January, Feb to February etc but I don't know how.
I have a table, populated some how, with the months, which looks like
...

**0**

votes

**0**answers

13 views

### Excel 2013 Collapsing issue while fetching from Cube

I am working with Excel 2013, using PivotTables. The fields in PivotTable are published into hieararchy so there are folders on top and field-values on bottom of hieararchy. What I am having troubles ...

**0**

votes

**0**answers

19 views

### Excel Solver - Can't set integer constraint on certain cell

I have a production programming exercise that I'm supposed to solve by using the Excel solver. However, I am not able to set an integer constraint on a certain cell that I need to be integer only.
I ...

**2**

votes

**3**answers

33 views

### How to convert integer column to time column?

I am trying to format an integer column to a time column, but the values all end up as 12 like this:
12
12
12

**0**

votes

**1**answer

12 views

### How to copy tab-contained text from Excel without quotes?

I've noticed that a cell that contains a tab is copied with quotes embedded. I'm looking for copying such kind of a cell without the quotes.
Illustrative Example
I've 5 cells; A1, A2, A3, A4, and ...

**0**

votes

**1**answer

30 views

### Using filter in Excel

I have an Excel file which contains details of all the school students from A to Z. Out of it, in a separate sheet created FEES DUE FORM for each class that contains only ROLL NO., NAME from APR '14 ...

**0**

votes

**1**answer

17 views

### How do I resolve data range failure from Excel?

When refreshing a data source in Excel 2013, I get an error about a data range. How do I stop this error from occurring?
I think that the error has something to do with removing connections because ...

**1**

vote

**1**answer

67 views

### Compare Two Dates and If Less than TODAY Add Date till TODAY and Add 6 Months to it [on hold]

I have data like this in
Column H
6-Feb-14
5-Oct-14
27-Dec-14
5-Feb-15
17-Feb-15
2-Apr-15
I'm trying to add 6 months to each date with the date being up to today.
Like if ...

**0**

votes

**0**answers

15 views

### XL 2013, how to enable triple click to select an entire block of text?

Previously in MS Excel I could triple click text to select an entire block/paragraph/sentence/whatever you want to call it. This seems to have vanished in XL 2013. Searching the web for an answer ...

**1**

vote

**1**answer

10 views

### Formulas in work calculations changing to “Automatic” though i choose them to “Manual”

I am using Excel 2013 and eachtime I change the formula calculations into "Manual" and save the file but when I open the excel, it is changing to "Automatic" by default. My file size is huge and I ...

**0**

votes

**1**answer

36 views

### Excel formula from VBA difficulty

I have a formula that I want to generate in VBA and put in a cell. The final formula is:
=IF(ISNA(MATCH(B6670,ProcMIRs!B1:B235,0)),"","Found in ProcMIRs row " & MATCH(B6670,ProcMIRs!B1:B235,0))
...

**2**

votes

**1**answer

22 views

### Save a multi-column custom sort for easy access by other users.

I have a large table in Excel 2013 which I will be distributing to a group of users. Each row in the table has a unique ID, with a combination of alphabetical characters, numbers, and periods. For ...

**0**

votes

**0**answers

23 views

### Microsoft Excel 2013 - Decimal Place Errors [duplicate]

Look at the difference of two values!!!
The third cell is the difference of the two previous values.
First case:
50.58
14.57
36.01000000000000000
Second case:
150.58
114.57
...

**0**

votes

**1**answer

33 views

### Excel # Different Then The Math

I have a formula in Excel that reads this:
=SUM(B6-F6)/H$1*100%
The numbers are as follows:
(.2500-.2503)/10*100.
When in Excel it comes out to -0.002 but when done by hand it comes out to ...

**0**

votes

**0**answers

24 views

### Iterating through dozens of Excel Sheets while summing up a specific cell or similiar stuff?

I have dozens of Excel files named very similar. For instance:
"I_XXX_YY_ZZZ Surname, Name" the only constant is the I, it doesn't ever change. Every single one of these excel file is made according ...

**0**

votes

**1**answer

29 views

### Copy range of cells within VBA module

I am trying to copy a range of cells in a specific sheet on the click of a form button
Sub Button1_Click()
Sheets("Marina").Range("A1:H10").Value = Sheets("Marina").Range("A13:H22")
End Sub
In ...

**0**

votes

**1**answer

11 views

### Excel - Truncating a pasted formula with multiple decimal places to two decimal places

We need to change a formula result that was pasted into a cell to a number with 2 decimal places. For example, formula number that was pasted was 3817.984138. We want it to paste as 3817.98. Can this ...

**0**

votes

**2**answers

40 views

### Excel 2013 Sorting alphanumerics with spaces

I have a list of Hebrew dates that looks like this (actually over 200 entries, of course):
Tammuz 5
Nissan 7
Tevet 10
Tevet 10
Tishrei 11
Av 2
Adar 1
Adar I 21
Tammuz 14
Tammuz 25
Tammuz 23
...

**1**

vote

**1**answer

18 views

### How to change excel legend order?

I have a excel graph with two lines using the primary axis and a column using the secondary axis. The legend currently lists the column first followed by the two lines. I would like to list the ...

**1**

vote

**4**answers

77 views

### How can I disable Excel 2013 on Windows 8 from asking for login credentials on some Web Query calls?

We've built a web query view in our application, returning some reports as a simple formatted table (with PRE tags etc. as required). Our app requires a login naturally, but its basically an API ...

**1**

vote

**0**answers

14 views

### How to copy and paste between cells without overwriting what would be in between in excel?

The wording is a bit complicated, but essentially the problem I am having is I have something like:
A| blank cell |C
B| blank cell |D
and I want it to be A|B|C|D all in one row.
Doing it manually ...

**31**

votes

**4**answers

3k views

### Get rid of all ##### errors at once in excel [duplicate]

In excel, I usually solve ##### errors by double clicking the offending column headers. However, this can get a bit tedious when there are multiple error columns. Is there a quicker way to solve this? ...

**0**

votes

**0**answers

23 views

### Auto Sum Conditioning Statement [duplicate]

Need help with making an autosum statement for the following chart, the final version will be much longer.
To Calculate #1, the calculation should be B2-B1 (since it is sold and in red), #2 would be ...

**0**

votes

**0**answers

30 views

### Can someone help me with an excel function that would make merging sheets easier?

I have about 61 spreadsheets that I want to merge into one big workbook.
Int the one work book I have tabs that are named the same as the spreadsheets that I want to import the data into.
There ...

**0**

votes

**2**answers

42 views

### Excel function to find the last three items by date

I am looking to obtain the 3 most recent transactions in relation to the date. (The problem is that they are in the spreadsheet out of order,
and I don't want to do a sort.)
Date Amount
...

**1**

vote

**1**answer

27 views

### Why have the hyperlinks in Excel 2013 stopped working?

I have used hyperlinks in an excel spreadsheet for years to connect to photo files of glass collection; over 1000 on one spread sheet alone. While the spread sheet was open we lost power, and when I ...

**1**

vote

**1**answer

38 views

### Why won't a comma work to shorten numbers? (# ##0.0,,)

I am trying to shorten some numbers in cells in Excel so that they display as millions. I tried putting two commas after the number format code in the custom category of the format cells dialog box, ...

**0**

votes

**1**answer

35 views

### Error in If Statement- Need Assistance

Working on a document that should be color coded when out of tolerance. When less than 1% go green, when more than 1% go red. What is the problem?

**0**

votes

**0**answers

62 views

### Edit Auto Sum Conditioning Statement

Need help editing totals when something is sold, it should subtract from totals.
http://i.imgur.com/9G8oTPU.png
To Calculate #1, the calculation should be B2-B1 (since it is sold and in red), #2 ...

**0**

votes

**0**answers

33 views

### Why is my Excel 2013 so slow to open URLs?

I have new install of Excel 2013 (32 bit process) on a fresh Windows 7 SP1 (64 bit). When I have a cell that contains a hyperlink to a website, clicking that link causes Excel to hang for 3-10 seconds ...

**0**

votes

**1**answer

20 views

### How to get a formula to extend to new cells depending on pivot table

I have a pivot table with some formulas using the data from the pivot table to the side of it. My problem is that if I add a filter, say city, so that the pivot table extends down, the formulas to the ...

**1**

vote

**1**answer

29 views

### Getting a webpage title into Excel

I'm attempting to create a cell that will pull in a hyperlink based off of what is filled out in another excel cell. I have the hyperlink portion working, but I'd like to have a better label for the ...

**1**

vote

**0**answers

58 views

### Dependent Drop Down lists and Data Validation; Multiple Lists

Right now, I have
My goal:
Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B ...

**0**

votes

**1**answer

24 views

### Auto Sum Totals in Excel

At the end on my Excel document I have my totals, and everything adds, but once something is sold (and is filled in red) I would like the price paid (column B) to be subtracted out of the total. What ...

**0**

votes

**0**answers

32 views

### Keeping multiple header rows visible while filtering in Excel 2013

I have read several other similar questions to this, however none of them capture exactly what I am trying to do.
My table has multiple categories. Each category has anywhere from 2 to 10 items ...

**0**

votes

**1**answer

28 views

### Excel 2013 - Referencing multiple checkboxes on a different sheet

Good morning, Superuser! I am facing a pretty tough problem at work this morning...my supervisor wants me to do something I have never done before, nor can I find a solution online.
The spreadsheet ...

**0**

votes

**0**answers

13 views

### Make changes in excel external datasource and send them to Sql Server?

I'm using data from Sql server as external data source in Excel.
But if I change data in excel, then the data won't change in sql server.
Can I make changes in excel and send them to sql server?
I'm ...

**0**

votes

**1**answer

29 views

### Variables not Initialized in Excel VBA Loop

I'm back with another question in VBA.
Here's the (updated) file I'm working on. When I try to run it, it says
Run-time error '92': For loop not initialized.
The loop is For Each var In accepted and ...

**0**

votes

**1**answer

58 views

### Excel Run Length Encoding

If I have a column of data in Excel that looks like:
1
1
1
0
1
0
0
1
1
Is there an easy way to convert it into a run length list that looks like this instead:
3 1
1 0
1 1
2 0
2 1
(Three 1's, ...

**0**

votes

**2**answers

21 views

### Initializing Variables

I'm working on a project that involves using Excel VBA. Unfortunately, I'm new to VBA and I think I ended up confusing myself while coding. Here's the file I'm working with.
When I attempted to test ...

**1**

vote

**2**answers

44 views

### Subtract milliseconds from Time in Excel

I have a logdata file with an end time, and the operation duration specified in milliseconds. I would like to subtract the duration from the end time, to get when the operation started. How can I do ...

**2**

votes

**1**answer

43 views

### How can I use Excel to monitor my payable?

Here's what I wanted to happen, I have five columns
Supplier Amount Payment Supplier1 Supplier2
When I have a receipt of my payable, I'll encode the name of supplier and it's amount. When ...

**1**

vote

**1**answer

37 views

### Budget planning with Microsoft Excel

I have an Excel worksheet which is regularly populated with daily expenses:
Then to extract a report on the amount of money spent on each category, I simply use a pivot table like below:
I am ...

**0**

votes

**1**answer

14 views

### Find missing values on spreadsheet 1 when compared to spreadsheet 2

I have the following scenario:
I have a list of ID's on a spreadsheet generated from a web app that has to be compared to our internal system. Any missing values from SP1 have to be alerted since ...

**2**

votes

**1**answer

39 views

### Excel, Setting a cap for values that meet a criteria on a column

I'm having trouble finding a way to limit the values of a column by setting a cap, but only for some values meeting a criteria.
An example of what I have:
>Criteria | Value
>--------- + ...