The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

0
votes
1answer
25 views

Excel Macro To Highlight Every Row Above Every Empty Row

I have an excel data sheet which is divided into data blocks of variable number of rows. Data blocks are separated from each other with an empty row. What I am in a dire need for is a macro that ...
1
vote
1answer
23 views

How can I compare two linked columns from one table with other two linked columns in another table?

I need some help on getting the proper formula for validating the following. We have Customer list with Customer name, Customer number registered in our system, Customer number in another billing ...
0
votes
0answers
9 views

Import Data to Excel from a Database View

I have an Excel file which requires to be filled with data from an Oracle View. Ok fine, I can create a Connection by going to Excel > Data > From Other Sources > Create a Connection to the View. ...
-4
votes
0answers
34 views

Still trying to find a solution [duplicate]

I need to create an Excel spreadsheet for my sales quotes. On one Tab, I want to list all of the possible services the customer could buy from me. I would simply click a box or enter a Quantitiy ...
0
votes
2answers
38 views

Excel crashes when opening new file

HP notebook 8570p Windows 7 64bit MS Excel 2013 Excel crashes under these circumstances every time: (problem started after Windows Update Dec. 2014) Excel is open, and a range in a workbook has ...
0
votes
0answers
20 views

Powershell Refresh Script

This is a fairly simple script, but it doesn't always work. It worked once today, the first time I ran it. I believe it isn't opening the files in the path I specified on subsequent runs. I'm not ...
0
votes
0answers
14 views

Excel unique entry duplicate sum per duplicate

I need to track the usage on my workspace. We have a Magnetic Stripe Reader that I have installed so that everyone has to badge in when they use the space. I need to figure out how to sum how many ...
1
vote
0answers
17 views

Excel Refusing to Do Any Sorting after 524,161 rows of data

I'm running into what appears to be a hard limit or something. At exactly 524,162 rows of data, I can no longer sort the data. Someone else claims they did 600,000 just fine. I have 32GB of RAM though ...
0
votes
4answers
20 views

Inserting specific number of rows in Excel

I, for the life of me, can not figure out why M$ has not provided this feature. If I want to insert 597, for the sake of argument lets say blank, new rows, all available information tells me to either ...
0
votes
2answers
33 views

Converting whole number to hour and minute format

I have data extracted from a database where the time format do not have a semicolon in between. Example 0810 should read as 8:10 and 1445 should read as 14:45. I want to convert those data in hour ...
0
votes
0answers
27 views

Excel 2013 crashes when saving instead of showing a pop up message “Some links could not be updated”

I need to prevent an Excel file from crashing and get a popup message instead. How can I do this? Below is the scenario: Excel 2013 crashes, when saving, instead of showing a pop up message "Some ...
0
votes
2answers
34 views

Conditionally Formatting Across Cells

I am organizing an event and would like to do the following: I have a General sheet with all the invitees names, addresses, etc. I also mark here if they replied and how many people will be ...
0
votes
0answers
12 views

How do I generate a sequential number in a single cell each time the file is opened?

I would like to automatically create a new purchase order number in a blank form every time I open the form, similar to the Today's Date function. Is there a way to do this in excel? I have Excel ...
0
votes
2answers
15 views

How can I write-protect a worksheet, while permitting link jumping to another worksheet to enter comments?

There is a very important MS-Excel sheet that I maintain, which I need to share with other colleagues. For every row in the particular worksheet that I maintain, multiple colleagues could leave ...
2
votes
1answer
32 views

Why does my Excel require pipes instead of commas in formulas now?

I'm using Excel 2013 on Windows 7 x64. Yesterday, I could write formulas using commas, like this: =IF(ISNUMBER(A1), "num", "not num") but today, I have to enter the formula using pipes, like this: ...
-1
votes
0answers
32 views

How do I SUM values in rows if several columns meet particular criteria?

Each week our company receives standard report which can't be modified. Description 01/11 02/11 03/11 04/11 "All-in-one C340" 10 1 20 4 "All-in-one C345" 10 ...
0
votes
1answer
23 views

How do I graph two columns not side by side?

If I have data like so: It's trivial to generate a graph/chart of Item v Quantity. However, how do I generate more complicated graphs/charts for Item v Items Cost. Extended minus Items Cost ...
0
votes
0answers
12 views

Formatting a chart with many data points for a small display area

In Excel 2013, I need to display a chart with dates on the X axis and errors (already computed) on the Y axis. The problem is that I have 916 data points taken every six hours spanning approximately ...
0
votes
0answers
8 views

How can I make a time by date chart in powerview

I am trying to produce a report of when an event first occurs every day. I'd like to produce a line chart using PowerPivot and Power View that shows the earliest time the event occurs as a line, with ...
0
votes
1answer
13 views

Does Excel 365 vba (or 2013) have the vbscript Regular Expression that found in Excel 2010

I'm considering moving to the cloud, but I use a lot regular expressions in Excel and was curious if Excel 365 had vbscript regular expressions.
0
votes
1answer
17 views

In Excel 2013 can chart titles be read from a cell in the worksheet?

In Excel 2013, can the chart title and axis titles be read from cells in the spreadsheet? If so how?
-1
votes
1answer
39 views

Solve .CommandType=0 error in excel

I am trying to run this macro in Excel that pulls data from a website in a loop. There is one table I need to pull from each of about 50 webpages and the loop is there to run the function that pulls ...
1
vote
1answer
43 views

Using a loop to extract data to excel

first timer here and I'm new to Excel 2013 so if I screw up somewhere let me know! I am trying to gather stats from the Detroit Red Wings from 1932-2014 I recently learned that I can pull data from a ...
0
votes
1answer
19 views

Excel saves absolute references to other sheets in my workbook. This causes problems when emailing the workbook to colleagues

I have this the following problem. I create a pivottable and set a reference to anther Sheet, for example: =Sheet1!A:C When I save, copy, cut and paste file to various locations, I end up with the ...
0
votes
0answers
8 views

Excel natural log scale

How do I plot a semilog plot in excel where one axis use a logarithmic scale (natural logarithms). I know I can switch an axis to logarithmic but then it asks for a base. How do I specify e as base? ...
0
votes
0answers
21 views

Return Code when opening Excel Files

I am trying to open Excel files and I am getting two different error messages when I do. First One: Second One: Any thoughts on why I'm getting these errors? Windows 7 Professional is the OS ...
-1
votes
0answers
99 views

Excel crashes upon performing regression

I'm attempting to use the Data Analysis add-in for Excel 2013 to perform regression, something that worked for me last week. Today, however, Excel crashes whenever I try to actually perform the ...
0
votes
2answers
26 views

Excel - Comparing two variable length columns, removing duplicates from both

I have two separate sized lists in an excel sheet - each around 150,000 columns. I need to find the unique values in one of these columns. From the ~150,000 records, I'd expect maybe ~800 to be ...
0
votes
0answers
28 views

Unable to open Excel or Word files in Office 2013

I updated from Office 2010 to Office 2013 last night. I am trying to open my Excel files now that I am using Office 2013, but when I do, the program opens up, but I only get a blank screen. I did ...
1
vote
0answers
9 views

Excel find and replace replacing replaced text

Why when using find and replace in Excel are cells already replaced being recognized and replaced in a new use of find and replace? Is there any way to prevent find and replace from changing cells ...
0
votes
1answer
39 views

Find minimum value in a row and return corresponding column name [duplicate]

How do I find the minimum value in a row and return corresponding column name? Month Price 1 Price 2 Price 3 Jan 10,000 20,000 9,000 So in the end I wish the formula to return Price ...
1
vote
1answer
20 views

Excel Fill from another sheet

My issue isn't setting up the formula that grabs the data from another sheet, it's filling the data with Excel's fill tool. So I don't have to tediously type/click every cell, etc. This is my issue: ...
0
votes
1answer
60 views

Copy Active Cell Comment in Excel into a new word file

i do not know much about Macros, is it possible someone could help me out. I have a simple excel file with names of Clients that have a lot of comments on each name. is there a fast way other than ...
0
votes
1answer
28 views

Excel item value data to line graphs with labels

I have a data set like this: Set Type x y S1 A 1 24 S1 A 2 87 S1 A 3 33 S1 B 1 66 S1 B 2 11 S1 B 3 20 S1 C 1 79 S1 C ...
0
votes
0answers
18 views

Match Timeline Axes Excel

I have a timeline plot with mixed chart types. There's a scatter plot to show a timeline, and I've used stacked columns to indicate period. This works fine at first, but there's a problem that the ...
1
vote
1answer
41 views

Excel file printing forcing margins

When I set my margins all to 0cm, and I have a portrait oriented page, the first top left cell in excel is like 2-3 mm from the top left corner of the page which is perfectly fine. However when I turn ...
0
votes
1answer
22 views

What is the unit of row height in Microsoft Excel?

In Microsoft Excel, Row Height is set as 15. What is the unit of 15? Is it inches, centimeters, etc.? I am trying to compare the height of the rows to a sheet of paper before I print it out.
0
votes
2answers
28 views

How i can calculate row in formula? making a link to specific cell

For example: Link to Cell A1 is "=A1" A - column name 1 - row number Can I calculate row number in formulas to make specific links? Something like =A{some calculations} so =A{1+1} will be a link for ...
0
votes
0answers
15 views

can I save a view of multiple worksheets in excel 2013

The image below is a view of two (2) worksheets in the same excel 2013 workbook. I made it using View--> View Side by Side, and the sizing each sheet, etc. Is is possible to save this view so that ...
0
votes
2answers
45 views

Get Last 5 Non-Zero Values in a Row

I have a large spreadsheet with many rows where the data can have zeros and positive/negative values but all numeric values. I would like to write a formula (or five formulas if needed) to tell me ...
0
votes
0answers
11 views

How to I auto-refresh an Excel auto-filter when data is changed in Excel Online?

This is a similar question to the one located here How to I auto-refresh an Excel auto-filter when data is changed? However i need the same functionality in excel online.
0
votes
1answer
43 views

Import external data connections into Excel 2013 for use in Excel 2003

I have a workbook in Excel 2013 that retrieves data from a SQL database via a query. However, the connection imports data as a table, which is incompatible with Excel 2003. Is there a way to convert ...
1
vote
1answer
29 views

How to have Office 2013 Applications Open to Blank (Workbook, Document, etc) automatically?

Every time I launch microsoft excel 2013 (or Word, etc) it gives me a screen where I need to select which template I want to open - How do I avoid this selection screen, like in other versions of ...
2
votes
1answer
244 views

Import one cell of data from one spreadsheet to another

I have one spreadsheet that is for global use in which I would like to incorporate one cell of data from various other spreadsheets to refresh anytime there is a change to the source. So for example: ...
1
vote
1answer
30 views

Can I produce an area chart specifying x and y coordinates

I'm trying to make an area chart in Excel in which I can specify not only the Y coordinates of each point in the series, but the x coordinate also, but it seems to not want me to specify anything like ...
0
votes
0answers
9 views

Excel legends are not positioning correctly

I have two excel pie charts and a line graph next to each other on a Dashboard. The pie charts look fine and are not touching the legends, yet they are disfigured in a way that the stings are lower ...
0
votes
0answers
40 views

Restore Multiple Document Interface on Excel 2013

Is there a way to restore the old Multiple Document Interface (MDI) to Excel 2013? i.e. when multiple Excel files are open, there is only one instance of Excel in the Windows taskbar. Some reading ...
1
vote
2answers
30 views

Calculate average depending on upper right cell

I'm trying to get the average depending on another cell. Basically I want the average of all cells where the value of the upper right cell equals 95. In this example I would like the average of A3, ...
0
votes
0answers
17 views

Excel 2013 Split One sheet into separate books

I have one sheet called Invoiced Jobs report containing the information for 10 invoices the invoice number is in Column X can I make a macro to split each invoice into a separate workbook?
0
votes
1answer
28 views

Excel histogram with discrete “bin numbers”

I have a column of data similar to this: 1 1 1 1 1.2 1.2 1.2 2 2 2.1 2.2 3 3 3 3 4 I want excel to display how many 1 values, how many 1.2 values, how many 2 values, etc. I know I should use ...