The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

18 views

### Excel 2013 rounding error

A B C
2.55
3.80 2.54
3.81 2.49
Average 3.81 2.53
% Difference 33.59580052
Trying to get the % diff between avg of column B ...

**0**

votes

**0**answers

19 views

### Excel: Storing a Path to Access a Closed Workbook

I have a workbook (let's call it A) which accesses another workbook (let's call it B) which is closed.
From A, I need to access data on B which may be on different worksheets. However, B contains a ...

**0**

votes

**0**answers

17 views

### Excel 2013 custom vlookup method

I have a workbook with over hundred worksheets that has monthly bonus calculation requests submitted (one for each employee) as well as a few other sheets that have the current monthly data such as ...

**1**

vote

**0**answers

24 views

### Performance Gain From Excel 2007 to 2010/2013 for modern PC

My work recently upgraded my department’s computers to shiny new spiffy i7 ssd 16GB RAM boxes. I spend most of my time in excel/access and the company still uses the 2007 versions of this software. ...

**0**

votes

**1**answer

11 views

### Nested Ifs for personal accounting sheet

I have a personal accounting sheet with 5 columns. C is Debit, D is Credit and E is Balance. I want to do 3 things but I've been confusing myself for the past hour.
If C5 and D5 are both blank, ...

**0**

votes

**0**answers

8 views

### Excel 2013 disable cell overwrite warning

I just did the upgrade. When I copy one cell to an already occupied cell, I now get a warning popup with an annoying bell. I've gone to Options and made sure the proper box was unchecked. I still get ...

**3**

votes

**1**answer

36 views

### Excel — Tell whether a string contains any value in a table column

Background
I'm using Excel 2013.
I have an Excel table named SiteCategories, with a number of Category columns, and then sites in those columns, like so:
So we could get to those values using ...

**0**

votes

**1**answer

30 views

### Excel T88 error

When a client opens an Excel 2013 file she will get this error.
I have tried to reset Excel and also an Office 2013 Repair but to no avail. Any ideas on what creates this?

**0**

votes

**1**answer

17 views

### Doing Excel calculation between sheets

Is is possible to do calulation on Sheet2 collecting numbers from sheet1?
The reason im asking, I have a *.csv who i import to a excel document. (sheet1)
When i do the calculation in sheet 2 i get ...

**0**

votes

**2**answers

24 views

### Copy multiple cells (not in range) from one sheet to another sheet

I've searched all over, and I'm unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet.
Eg, Copy Cells, A10, F2, F3 & F34 from ...

**0**

votes

**0**answers

6 views

### Multiline formatted dynamic footer

In Excel 2013 there are few options how to create rich formatted page footer. I need a couple of lines from a worksheet to appear on fixed place at the page bottom as a page footer when printing.
I ...

**1**

vote

**2**answers

21 views

### Move each Cell after column A on new line

I would like to export some data into MySQL, however before that I would like to format the data. I am not sure how to explain it, so I made some screenshots.
How could I turn this:
Into this?
1 ...

**0**

votes

**0**answers

17 views

### 3 conditions in a nested Excel formula

I am using 3 conditions in a nested formula, each condition has a number of variants. So far
=IF(I14=60,IF(AND(H10<10,D75=1),0.5,IF(I14=60,IF(AND(H10<30,D75=1),1,
and so on.
This works ...

**0**

votes

**1**answer

12 views

### excel 356 serialisation numbering

I can't conceive of the function expression I could use that would result in the following number set. To be clear, column A is my source data, column B is the result I want - but by using a formula ...

**0**

votes

**2**answers

40 views

### Aligning Stacked Bar Chart w/ Scatter Plot Data

I have a scatter plot that has several data points at regular intervals, e.g. (8, 10) (8, 15) (40, 12) (40, 9), etc.
I'd like to have a stacked bar chart that lines up with these intervals, but so far ...

**0**

votes

**1**answer

27 views

### Check which (multiple) cells in column A contain substrings specified in column B?

In column A I have M&A deal descriptions that mention company names. In column B I have company names, for each of which I want to see where it is mentioned in column A.
What I'm having trouble ...

**2**

votes

**0**answers

24 views

### MS Excel 2013 function TODAY() not updating unless source file is open

I use the TODAY() function in an excel worksheet which is accessed using MATLAB (i.e. I don't read the worksheet directly). Now I have to open the excel file just to update the TODAY() function, and ...

**1**

vote

**1**answer

21 views

### Copy an excel file with Macros and New Tabs in the ribbon to another computer

I'm working with Microsoft Excel 2013. I'm using couple of macros I did and I made a new tab in the ribbon menu which shows the macros I did so that I can click on the this created tab then click on ...

**0**

votes

**1**answer

26 views

### Merging five colums but do not merge if row contains two values

I have 5 columns all with numeric data in. R S T U V
The first three columns can be seen here so you get the idea. I want to merge them all into the first column "R" - in the vast majority of ...

**0**

votes

**2**answers

56 views

### How to lookup a value and return multiple unique values to a single cell - comma separated

I am attempting to lookup a unique identifier (Product Number) which is held in several different stock locations. For example:
__A__ __B__ __C__
1 Item # Warehouse ...

**2**

votes

**2**answers

21 views

### Show decimal places if not a complete whole number

I have numbers in cells in Excel. I want the numbers formatted so that if they have decimal places they show to a maximum of two, and if they have no decimal places it doesn't show any.
For example:
...

**0**

votes

**1**answer

19 views

### Search two columns in Microsoft excel 2013 and set the value of a third column with a specific value

I want to search a specific text which is the firstname_lastname e.g John_Smith in worksheetA. WorksheetA has a column firstname and another column lastname. So after knowing which row has the ...

**3**

votes

**1**answer

77 views

### Extract number from complex string if it falls in a given range

I need an Excel formula (or VBA macro) that will allow me to extract a value
from a string. The string is a sequence of words, separated by spaces, in a single cell. I want the word (representing a ...

**1**

vote

**3**answers

43 views

### Remove spaces between characters in cell, but only if the space exists between two single characters

To process in 10,000 lines of excel, to remove spaces between characters in cell, but only if the space exists between two single characters.
P J A JACKSON AND SONS
should become
PJA JACKSON AND ...

**3**

votes

**1**answer

67 views

### INDEX + MATCH function returning wrong values

I have a spreadsheet in Excel 2013 that uses an INDEX and MATCH function to search by an interval time (in I4) to pull values from the corresponding row where it is matched (in column A). It works as ...

**0**

votes

**0**answers

18 views

### Sorting data by association?

That title may have been misleading, I don't know quite how to put it.
I have a set of data where a number stands for a description. It currently looks like this:
10 Blue
11 Green
12 Purple
13 Red
14 ...

**1**

vote

**1**answer

120 views

### Excel 2013 opens files slow in Windows 10 (when not in Safe Mode)

This is a problem that has come up on Google and superuser in the past, although the solutions I have found haven't worked for me.
If I run Excel 2013, it opens instantly. If I am in Excel and open a ...

**0**

votes

**0**answers

16 views

### Append row of Excel data to TXT file with regular interval

I want to transfer data from Excel file to TXT file in a timed interval.
I have a row in Excel with 50 parameters (from A1:AX1).
The values of these parameters always change (these values are ...

**0**

votes

**0**answers

23 views

### Outlook 2013 crashing when opening .pst file

So we've been having this issue with Outlook recently which seems to have stumped Microsoft answers for over a year and a half, the most recent post being the one posted by one of our people.
List of ...

**0**

votes

**2**answers

25 views

### How to split text with a comma delimiter in a lined cell?

I need to split an address into rows for postage.
In Tab 1 I have my members details
In Tab 2 I have my Invoice that we mail out.
In Tab 2 I run a VLOOKUP function to pull the member's details from ...

**1**

vote

**2**answers

29 views

### Excel: how to convert text to number?

I copied some table with products and prices from a web page to a Excel (2013) worksheet.
Both the source table and my own Excel are configured with French number settings: a thousand euros and 20 ...

**0**

votes

**1**answer

24 views

### Link large number of cells to different files in one go?

I have a folder with lets say, 500 further sub-folders within it.
In Excel, there is a document with a corresponding list of numbers, which I link through to manually.
AE 0001 through to AE 0500 for ...

**0**

votes

**1**answer

37 views

### Excel - How to check if and in how many rows a certain value/string is present in range

I have a list A of strings and I want to see if and if yes in how many rows each string is represented in range B. My data looks something like this:
List A:
aaa
bbb
ccc
Range B:
1 aaa --- ---
...

**1**

vote

**1**answer

15 views

### Conditional Formatting in Excel via a different worksheet

I've been trying to figure out how to make a cell bold and color red based on conditions entirely in a different worksheet. For example, I'd like Sheet1!A1 to be bold and red when Sheet2!A1 = ...

**1**

vote

**0**answers

41 views

### Can I make Excel keep a history count when a selection is made? [on hold]

I have a drop down list people (Data on Sheet#2) and I would like to keep a running total every time these people are selected under the drop down list for the type they were selected for.
Example: ...

**0**

votes

**1**answer

21 views

### How can I use vlookup function for multiple table array that has different length?

I need to import the minimum value form Column C to column B for each item, but the problem is that the table array is different for every item.
Since I can't upload any image, I will just type the ...

**1**

vote

**0**answers

34 views

### If Data Allready Exists In A Cell Overwrite It With New Data

I have an excel sheet with IDs beside cases. When I work the case and get a reply I want the excel spreadsheet to work out its the same case and update the original without adding a new case onto the ...

**0**

votes

**1**answer

28 views

### How do I highlight the max values across every column in a pivot table?

Looking for a way to use conditional formatting to highlight the max value in every column of a pivot table.

**1**

vote

**0**answers

45 views

### “Microsoft Excel is waiting for another application to complete an OLE action” interrupting VBA code

I've got an Excel workbook that is running some VBA code, which I use every day. During execution, it keeps hanging on a dialog box saying "Microsoft Excel is waiting for another application to ...

**1**

vote

**1**answer

131 views

### How do I add new row in Excel *below* the current one?

The Insert > Insert Sheet Rows command in Excel always inserts a row above the current row. However, it is quite a common scenario for me to want to insert a row below the current row, like this:
...

**0**

votes

**0**answers

7 views

### Trying to delete duplicate rows in which columns A, B and C match [duplicate]

I have a list of over 15,000 emails. I need to delete any rows that are a duplicate. I need columns A,B and C to match for them to be deleted. How can I do this?

**0**

votes

**0**answers

3 views

### excel: how to access xsd file that is already in an xls

I have an xls file with an xml map(.xsd) already loaded. Is there a way to extract the contents of the .xsd file? I want to take a look at the source.

**0**

votes

**1**answer

22 views

### Count unique values in column by month with blanks

I have 2 columns I am comparing. One column I want to count unique numbers. I want to quantify this unique count by month. (Work Orders per Month).
I'm using:
...

**0**

votes

**1**answer

15 views

### Excel - Scatter plot does not connect all data points

in Excel I have a chart with 5 scatterplots. The x-axis is always the same column. However, the last added scatterplot does not connect all data points (see figure). There are some blank cells in the ...

**0**

votes

**0**answers

27 views

### Excel show drop-down list based on selection from second drop-down list

I have a drop-down list, let's say, for example, you have the choice to select between fruits and vegetables from cell A1
When you select fruits, the drop-down list in cell B1should show a list of ...

**0**

votes

**1**answer

28 views

### Sum up values from two lines but keeping some columns seperate

I want to sum up the values in Column C for rows with same Column B value.
In my example the values for A Dunn and G Birch should be combined, with the bottom line going blank
But column A (account ...

**-2**

votes

**1**answer

37 views

### MS365, Excel 13 - New row added not auto updating formulas

I have a table in Excel I made myself not an inserted one - though I have tried that too it didn't do anything. The problem is at the end I add a new row and none of my formulas are in the new row. My ...

**1**

vote

**1**answer

23 views

### When using a named ranged in Excel (2013), how to display the entire range, but offset one cell?

I have a range $A$2:$G$2 named Distances; later in the sheet, I want to populate the range B11:H11 with the data in the original range. I can start in cell A11 and type =Distances and it will populate ...

**0**

votes

**0**answers

14 views

### Excel changes chart layout when I save as template

I created a chart layout that I like and replicate across numerous other charts. I saved it as a template. When I go to apply the template, the preview is different than my current chart. When I apply ...

**0**

votes

**1**answer

16 views

### Excel 2013: stacked bar chart with date, updating date issue

I have a stacked bar chart, with time and duration in Excel 2013 (I'm trying to show 30 day milestones). I had no problem the first time I created the file.
Now that I need to update the dates (to ...