The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
0answers
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
0answers
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
0answers
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
3answers
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
1answer
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
1answer
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
4answers
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
0answers
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
4answers
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
0answers
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
0answers
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
2answers
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
1answer
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
1answer
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
1answer
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
0answers
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
0answers
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
1answer
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
0answers
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
1answer
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
1answer
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
2answers
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
2answers
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
1answer
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
1answer
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
1answer
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
1answer
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 >--------- + ...