The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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