The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**4**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**2**answers

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

**1**answer

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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