The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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