The 2013 version of Microsoft's spreadsheet application.

**0**

votes

**1**answer

18 views

### Microsoft Excel 2013 - Continual subtraction?

So to make my question as easy to understand as possible, I am in the process of writing what will start out as a table-top/text based style RPG game. I already have formulas for all my battle ...

**1**

vote

**0**answers

25 views

### Create dynamic formula so that one Excel table looks-up the same column name in another table

I have two Excel tables, table A and table B. Table A contains the columns Customer ID, Postcode, Customer Name and several others that have the same column names as columns in table B. I want to ...

**0**

votes

**1**answer

16 views

### Send bulk mail using Excel VBA

Was working on a project which will be sending bulk mail to different people if the conditions are met.
Conditions :
Column U contains the final status (Open or WIP) (will not send if
Closed no ...

**0**

votes

**0**answers

15 views

### Pivot Table to Show Percent SUCCESS Scores ONLY

How would I adjust the pivot table to show only the percent of scores with SUCCESS and hide the FAILS? Hiding the fails changes the SUCCESS scores to all 100%. I can hide rows in the pivot table, ...

**0**

votes

**0**answers

6 views

### The graphical values do not synchronize with the y axis in excel

When I enter some figures in excel the graphical values do not synchronize with the y axis when plotted. Example I could have -650000 but the graph will be above or even below that. If I also increase ...

**0**

votes

**1**answer

29 views

### Convert a password protected Excel file to CSV without Excel

I have a number of password protected Excel 2013 files that I know the password for. Is it possible to convert them to CSV in batch and without Excel?
I have looked into Docrecrypt but I do not have ...

**0**

votes

**0**answers

14 views

### excel froze and after killing the process excel file has disappeared

I'm hoping someone can help me. At work, my Excel spreadsheet froze while I was working in it. I couldn't type or move into any cell, nor could I save or close the file. I was able to use the Task ...

**0**

votes

**1**answer

39 views

### Comparing two sets of data

Column A is a list of names and column B details their phone number. I have an updated list of names and phone numbers in columns C & D . I want a formula that is able to detail any change of ...

**0**

votes

**1**answer

59 views

### Microsoft Excel Data Table

So I have a lot going on with my current table, I use it for showing my portfolio in a snap:
Except it's lacking a pretty looking pie chart. Here's the thing, I can do what others have suggested. ...

**0**

votes

**3**answers

51 views

### need to print a sequence of numbers on excel 2013

I have an Excel sheet and I resized the print area to print on A5 size.
Now I have 2 cells that fit in the "A5" paper and each one has a number.
What I need is to print numbers from (1 to 5000) with ...

**0**

votes

**0**answers

16 views

### Comber cell contains to rang (not match not vlookup not index)

Blue is range "Alist", cell yellow which contains names which one of them is to be compared ie, if the yellow cell contains a name from blue range = OK.
How to return the value of the green cell to ...

**-2**

votes

**0**answers

14 views

### How to reset/delete a CSV every time it opens? (I only need the latest data)

I was just wondering if there is a way to automatically delete the data in a CSV file every time you open or close it? If this is not possible, is there a way to extract a certain portion of data from ...

**1**

vote

**2**answers

47 views

### How to select the first number in cell in Excel?

I have a table that stores both a number and some text in a cell, and I want to do an arithmetic operation based on the numbers. So my table looks like this:
Number1 | Number2 | Product
2 ...

**0**

votes

**1**answer

8 views

### What formula do I need to use to update an inventory using an updated spreadsheet

Here's my question, I'll try to be as clear as I can. I am in charge of keeping our inventory up to date, (our company sells products to customers using several different online stores). I have two ...

**0**

votes

**1**answer

37 views

### How do I make a horizontal single row high low close chart?

I am using MS excel 2013.
I would be grateful if someone could point me in the direction of a function or workaround in excel that will help me to build a small single line chart to be included in a ...

**1**

vote

**0**answers

20 views

### Table relationships across 3 tables and updating all with a single slicer

I have 3 tables with data. All of which have a username column and I'm trying to connect them.
For this purpose I have created a 4th table which is basically just the User directory (where each ...

**-1**

votes

**1**answer

30 views

### Compare 2 sets of data in EXCEL and return what it should be

I need some help with comparing 2 sets of data in Excel (see screenshot below).
As you can see I have data from 2 sources. Source 1 is the correct data. Source 2 may have been correct at some point ...

**0**

votes

**1**answer

35 views

### How to automatically create large number of columns in Excel 2013

I would like to start a new excel spreadsheet, create a column named Column1, and quickly fill in increments, (Column2, Column3 etc) up to Column500. Is there an easy way to do this?
Also is there ...

**1**

vote

**1**answer

21 views

### Show Form from cell click, then CommandButton to pass to next ActiveCell

I'm creating an input form for use with a 'tablet' PC in Excel for our guys to fill out when in the field. As inputs like drop-down menus and the like are quite fiddly, I wish to use a basic input ...

**0**

votes

**0**answers

9 views

### Excel 2013 copy formatting to all instances

I have cell values in sheet 1 (cover sheet) that contain specific fill formatting. How would I copy the formatting of the cell value to all sheets in the workbook that contain the exact value?

**-1**

votes

**2**answers

39 views

### Excel 2013 - combine conditional formatting

Excel 2013, Windows 7 Pro.
I have a spreadsheet with some Conditional formatting, but I need multiple rules & I don't know how to make them work correctly together.
1) First, I want one specific ...

**0**

votes

**1**answer

47 views

### Excel 2013 Pivot Table refusing to summarise identical values - returns duplicate results. Why?

I've encountered a bizarre issue whilst building a simple pivot table in Excel. Here are my data: I've created a simple table with col C containing values in A divided by those in B. I have included ...

**0**

votes

**0**answers

11 views

### Extract/ copy coloured cell data to another sheet in Excel

I want to extract/copy cells data that are coloured to another sheet

**0**

votes

**0**answers

28 views

### Function To Lookup Values From Pivot Table

I have been trying to use VLOOKUP() to return values from a pivot table but all I ever get is #Ref I tested my theory that the issue is the fact that I am trying to return the data from a pivot table ...

**2**

votes

**0**answers

45 views

### Excel 2013 not starting properly

At our office we all work with Office 2013. Today one of our employees was unable to start Excel. It seems that the program does start, but only shows a very limited screen:
I am unable to minimize, ...

**0**

votes

**1**answer

22 views

### Space values in line graph by Y value instead of equally

If I have a table of data that looks like this:
Time (seconds) Data
1.1 4
1.2 4
1.31 7
1.4 8
1.91 11
2 9
2.1 5
2....

**0**

votes

**1**answer

20 views

### Two Columns, need to match a string from one to another

I have two columns of Data.
Column A Contains cells (105k) path directories with filename
Column A
C:/Im/Not/GoodAt/excel.pdf
C:/Im/Not/GoodAt/exce1.pdf
C:/Im/Not/GoodAt/excez.pdf
C:/Im/Not/GoodAt/...

**0**

votes

**1**answer

28 views

### Using SQL to merge .xlsx file and over 1,000,000 rows?

I'm having trouble with an operation that I believe is limited by the shear size of the data - the operation is a merge and filtration of two Excel workbooks, each with over 1 million rows.
Perhaps ...

**0**

votes

**1**answer

21 views

### Using IF(Isnumber(Search) formula - Excel 2013

I am looking for a formula that:
If c7 contains text: "Payables" OR "Corporate" then Text 1, if false then "Text 2"
Currently using formula =IF(ISNUMBER(SEARCH("Payables",$c7)),"Text 1","Text 2") - ...

**1**

vote

**1**answer

33 views

### How to generate an excel chart that includes aggregating and grouping

My data looks like this
Date Time Person Logged in
June 1 2PM John
June 1 2PM Chris
June 1 3PM John
June 2 2PM Chris
June 2 3PM Bill
June 2 4PM Bill
I want to ...

**1**

vote

**0**answers

13 views

### How to increase the length of the filter/sort menu in excel 2013

I'm using the filter option to select through a list of "n" items in Excel.
The items are sorted in ascending order.
This is how the filter/sort (pop-up or context) menu appears when I click on it.
....

**0**

votes

**1**answer

24 views

### Remove space in cells that is creating a new paragraph within the cell

I have few cells in my .csv file that has space between lines that is creating a new paragraph within the cell. So when I click on that cell only the first line of the cell is displayed in the formula ...

**1**

vote

**1**answer

64 views

### Deriving elegant or 'nice' axis values on graphs using Excel - lookup function or formula

I am trying to automatically calculate the most elegant y-axis scale (maximum, and division value) for some bar charts. I'm using Excel integrated with a dashboard tool (SAP Dashboards) to display two ...

**0**

votes

**0**answers

20 views

### Make words fat using function bar

Is there a way in MS Excel 2013 to format words fat/thick using the function bar?
I need the concatenating function and want to highlight each cells information
with an additional section like title ...

**-1**

votes

**1**answer

44 views

### vlookup - Is it possible to use vlookup to pull specific info like this?

I am trying to pull the following from each group of Numbers -
CHG000509443 05-16-2016 22:48:41 for the Requested
CHG000509443 05-17-2016 13:14:35 for the Approved
Note 1 - It is always the first ...

**0**

votes

**0**answers

18 views

### PERSONAL.xlsb not opening automatically

For some reason, my PERSONAL.xlsb file is no longer opening automatically.
I've checked the Trust Center and the file location (C:\Users[user]\AppData\Roaming\Microsoft\Excel\XLSTART) is a Trusted ...

**1**

vote

**1**answer

24 views

### Excel2013 - Grabbing data from specific cells based on the selection from a drop down list

Depending on the selection from a drop down list, I need to match data from a specific cell into another cell. I have a list of Team Members and depending on which area they work in during a shift ...

**0**

votes

**2**answers

31 views

### In a PivotChart filter, how do I select a just range in the column to display?

Help! I have created a pivot chart that shows 3 data series across iterations (time). All series are shown as 'running total in' base field: iterations.
The series are:
Total Hours Planned
...

**-1**

votes

**1**answer

53 views

### Excel 2013 VBA script needed for [closed]

I have several cells that have a string of text that are partially Bold and partially NotBold. I need to delete the Bold portion of the Text in the Cells
Example:
lname1, fname1email1@email.com
...

**0**

votes

**1**answer

32 views

### Return Non Null Cookies And Count

I have two worksheets in my workbook. The first worksheet is titled SalesPerson and should show a rundown of the salesman that is entered in cell B1 and the type & quantity of cookies sold. ...

**1**

vote

**1**answer

45 views

### Running Parameterized Stored Proc From Power Query

I have been following the tutorial HERE but anytime I try to refresh the workbook, it gives me an error of:
DataSource.Error: Microsoft SQL: This database function doesn't support the query option ...

**1**

vote

**1**answer

39 views

### Find the number of points between two “scatter with smooth lines” series

I've attached an image that shows the scatter plot I've built in Excel. I need to know how many points are between the dashed line series and the solid line series just to the inside of the dashed ...

**0**

votes

**0**answers

18 views

### Deducting duplicates values

I have a table in Excel A, B , C & D
in Column A i'll enter item row wise(Dp 2310, J800....It'll include duplicate items.
In column B, It'll calculate how many items received (against particular ...

**0**

votes

**1**answer

43 views

### MS Excel - I wish to count unique values based on a parent column

I am very new to Excel. I need some help in counting unique values in each of three columns (considering them only one at a time) with respect to a parent column (the first one (A) in the image). Can ...

**0**

votes

**1**answer

38 views

### Data validation to give text a value that's used in a formula elsewhere on the sheet

We have a group planning to charter a sailboat as a vacation for 10 days. I'm trying to show the total costs of the trip. It's a simple spreadsheet listing many semi-fixed costs like food, beer, ...

**0**

votes

**1**answer

17 views

### If statement with indirect problems

My sheet is set up with I1 as a drop box for other tabs.
A1 and B1 Formula works and pulls the info from the cell in the tab if there's info, with slight changes in formula for cells but you can get ...

**0**

votes

**1**answer

75 views

### Strange “freezing” behaviour in Excel 2013 brand new XPS 13

I have a new XPS 13 with 16 GB mem, i7, windows 10 64bit and since I got it a few weeks ago I have been having the following very annoying problem.
At random times the excel GUI disappears, although ...