The 2013 version of Microsoft's spreadsheet application.

**1**

vote

**2**answers

20 views

### How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser.
The entered value then should, for example, look like this:
superuser template
If the user enters super user template (with a ...

**0**

votes

**0**answers

23 views

### How to change a military time schedule into a standard time schedule

I have a military time schedule as shown below:0500-1300or1330-2100Is it possible to convert said cell values into standard times; 5:00AM - 1:00PM, without having to use a text-to-column function?

**0**

votes

**0**answers

10 views

### Web Scraping with Macros in one sheet

I got this code to download web pages, but it download each page in a separate tab. How can I make it store all in one tab till its filled than make another and so on?
Code:
Sub adds()
For x = 1 To ...

**-1**

votes

**0**answers

17 views

### Excel 2013 autofill not working as expected [on hold]

I have a numbers in the first row. I multiply them with 2 in the second row by equation which was written in the first cell in the second row and drag it to the end of the row. the problem is the ...

**0**

votes

**1**answer

28 views

### Excel 2013: moving X-Axis values to the middle of the columns

How could I move the X-Axis values to the middle of the columns?
For example, the month values in the chart below (it's not my chart, it the state I want to reach) appear in the middle of the column. ...

**0**

votes

**1**answer

17 views

### Conditional Formatting not obeying rules

Why does Excel treat empty cells as a value for conditional formatting when the rule used clearly states:Format only cells with: Cell Value greater than or equal to 0.0625 "0.0625" is clearly NOT a ...

**1**

vote

**1**answer

30 views

### How to convert a non-time text value into proper time

My spreadsheet has time values as shown:
:15
:00:23
:47:15
Excel does not see those as actual time values, but instead returns their values as text. Therefore, math functions will not work because ...

**0**

votes

**2**answers

22 views

### How can I prevent changes to formula results after first use?

We have an Excel 2013 workbook that we use when we create new user accounts (column A for first name, column B for last name, column C for the password, etc.).
First name Last name ...

**0**

votes

**0**answers

8 views

### Prevent Field Collapsing in Excel PivotTable

I am working with Excel 2013 Pro, using PivotTables. The fields in PivotTable are published into hieararchy so there are folders on top and field-values on bottom of hieararchy. What I am having ...

**0**

votes

**0**answers

9 views

### Issues with Excel pivot table denying access to original file

I currently have a pivot table that is referencing an external data source. The connection is to another excel spreadsheet on our shared server.
When importing I select the tab that I want to use and ...

**2**

votes

**1**answer

39 views

### Office 2013 has become unusable

Office 2013 has become unusable.
Until a few days ago it worked.
At startup appears a white window with horizontal banding. In these conditions you can not select the options to disable the use of ...

**0**

votes

**1**answer

17 views

### Excel Conditional Formatting greyed out

So I have a sheet open in Excel 2013. I have come to add some conditional formatting and cannot do so due to it being greyed out.
My suspicion is that it is due to this [Group] thing. I know that ...

**1**

vote

**1**answer

22 views

### Macro to Copy Hyperlink from Another Sheet [on hold]

I have a Macro that I found on this site to copy hyperlinks inserted through the ribbon to a different column in another sheet. However, the macro is only working on the first row.
I added Do until ...

**0**

votes

**1**answer

27 views

### Simple sum of dropbox values for scoring Excel 2013 worksheet

I would like to make a worksheet with dropboxes for scoring ingredients and summing the scores per ingredient. I already made the dropboxes with number 1-3(1=poor, 2=fair, and 3=good), but I would ...

**0**

votes

**0**answers

18 views

### Powerpivot, Calculate(SUM()) with OR Statement?

I've trying to sum a column with multiple or condition, and I haven't been able to figure out how
I could simply have multiple formulas like
calculate(sum(), filter1)+calculate(sum(), ...

**0**

votes

**0**answers

10 views

### Excel Data From Web - Refresh All fails/never finishes

I have a sheet that makes 4 web query connections to HTML tables. The pages that are imported are purpose-built pages that only have one HTML table with 5 columns.
The web pages load in 1-2 seconds. ...

**1**

vote

**1**answer

21 views

### How do I prevent F1 from opening help in Excel 2013, without using VBA?

How do I prevent F1 from opening help in Excel 2013?
The only information I found elsewhere entailed using VBA or, for the whole system (I'm using Windows 8), editing the registry. I would prefer to ...

**0**

votes

**0**answers

26 views

### How to export images from Excel table [duplicate]

I have an Excel table with two columns: id and picture.
id is a string and picture contains a single jpeg picture.
This table contains almost 1,000 rows.
Is it possible to export the images as jpeg ...

**0**

votes

**0**answers

20 views

### How can I link worksheets containing merged cells?

I have a large worksheet (over 8,000 cells) of manually inputted data, more than 70% of which is comprehensive qualitative (text) data, with the remainder being numeric. In other words, I'm treating ...

**2**

votes

**0**answers

11 views

### Pivot Table Slicers. Can I ensure one specific item is always selected?

I'm using Excel 2013.
As in the title, I have a slicer (connected to a pivot table and pivot chart) and I'd like to make sure one specific item in my slicer is always selected whilst allowing ...

**0**

votes

**1**answer

46 views

### MS Excel - adding line to some series in stacked bar chart

I built the following chart after some googling:
It has two levels of category axes, the bars you see are stacked bar chart types. You can find the file with the data and the charts here if you ...

**-1**

votes

**1**answer

42 views

### How can I create a chart to show a possible pattern [closed]

I have 3 columns in my table.
Date Day of Week # of hours
11/27/2013 Wednesday 7
2/4/2015 Wednesday 7
3/18/2015 Wednesday 7
5/2/2013 Thursday 2.5
5/15/2013 Wednesday 2.5
...

**1**

vote

**1**answer

36 views

### Excel pivot table, difference between fields in the same column

I have table that has the same account names but for different years (sample below). I want to create a pivot item field that calculates the difference between the years for the same account name
...

**-1**

votes

**0**answers

12 views

### Converting Excel data into a horizontal calendar

I am currently working on some Excel data and need to format them into a calendar without using VB.
Would any of you have an idea how to do it?
I need to go from something like this:
To ...

**-1**

votes

**0**answers

22 views

### Extracting columns from an Excel file

Here is my scenario:
There is a certain service that creates summary reports each week. This is an Excel file with a number of rows and columns. One of these columns is an ID. Think of this as the ...

**0**

votes

**1**answer

16 views

### Converting a column list from A2:A142 to a list with commas into cell B1; holding a format as “0000” with leading zeros

This code works to convert the column list to a concatenated list with commas, however the format doesn't have leading zeros while the VBA loops in B!.
Dim i As Integer
Dim s As String
i = 2
Do ...

**0**

votes

**1**answer

29 views

### How to put Tables inside a “Master Table”?

I've been getting a beating by Excel recently! :)
I want to make a "Master Table" that comprehends all of the other tables in my workbook. The problem I'm facing is that if I just refer to the cells, ...

**0**

votes

**2**answers

32 views

### Use INDEX to lookup multiple values in a list

I am using this formula to Look up all instances of CUCUMBERS in column B on the first sheet of my workbook: "ITS" I have identical to column B in Column X.
So far this works great, just as I want ...

**0**

votes

**1**answer

32 views

### What prevents Excel from staying current with the years. For instance, why aren't I using Excel 2015? [closed]

Just curious on why Excel (along with other Microsoft applications) are not "up-to-date".

**1**

vote

**2**answers

26 views

### How do I insert columns without changing cell reference of a formula?

I have the following formula in cell A1 where I am simply adding and subtracting some numbers...
=B1+D1+F1-C1-E1-G1
And I repeat this going down to row 100 such that the formula in A2 is...
...

**0**

votes

**2**answers

37 views

### Excel: Validation rule with value that should be in the list of another column without blank

On excel, I've two tabs: one listing all people participating to an event, with a lot of details. I've a "FullName" column which is basically defined by:
=[@LastName]&" "&[@FirstName]
This ...

**1**

vote

**1**answer

36 views

### How to count months in intersection of two date ranges [closed]

I need to calculate the number of months in the intersection of two date ranges.
For instance, in Column A I have start dates of employment
12/1/1998, 1/1/2003, 2/1/1995
and in column B I have ...

**0**

votes

**1**answer

28 views

### EXCEL: Additional COUNTIFS / Condition Needed for Value Ranges

I am recording multiple channels from individually housed birds, and sometimes their vocalizations bleed-through to other channels.
I want them to be tagged for removal in some way. ...

**0**

votes

**1**answer

30 views

### Conditional formatting- use a formula

I'm getting a bit tripped up with Excel. I've got 5 columns of retirement account contributions and balances over 30 years, and I'm trying to highlight the year where the year-end balance first ...

**0**

votes

**0**answers

17 views

### making a running total for excel using countif function, 1 out of 14 drop down options don't work

So im using a table in excel, with several different headings in several collumns, (not pivot just standard) colomn A's name is "status", under these headings are several (about 900) different cases ...

**0**

votes

**1**answer

15 views

### Office 2013 - Excel function

I am using excel 2013
In Column 3 I have a list of airline names
In Column P I have percent for each carriers data...show as 60.047% i
I would like to have ever number >=1* to highlight the adjacent ...

**0**

votes

**2**answers

24 views

### Calculating the deviation from range of values?

I'm trying to find if there is a function to do what I could do with several IF statements, just to make it more robust and standard I suppose (and more readable)
I have a spreadsheet with 4 columns ...

**0**

votes

**2**answers

26 views

### Removing the duplicate values and showing them in a new sheet [duplicate]

I have created an excel file for deliveries in my company and when we order products i put their dispatch number in the file. But when I try to check these dispatch numbers with post I always have ...

**0**

votes

**0**answers

12 views

### automatic insertion of the date of filling an adjacent cell in excel [duplicate]

I have created an excel file for my company and several people have access to this file. because of that I need to know when a cell is filled. I want to dedicate a cell to show the date and time of ...

**0**

votes

**1**answer

5 views

### Validate range of values against another range of values in Excel

Similar to how CountIf validates a single value against a range of values (or, CountIfs validating a range of values against criteria), is there a way to validate a range of values against another ...

**0**

votes

**1**answer

27 views

### How to open multiple concatenated hyperlinks at the same time?

I used the Concatenate function to join links like this:
Column 1: http://twitter.com/
Column 2: username
Column 3: http://twitter.com/username
I actually wrote the function like this:
...

**0**

votes

**1**answer

24 views

### Excel 2013 If Function calculates True when condition is not met

=IF(I12="Y", J12*K$11, 0)
But, if I12 is blank, it calculates J12*K$11 anyway.
I've tried text, general and number formats for I12. This calculation works as a test in a new worksheet. J12 is a ...

**0**

votes

**0**answers

24 views

### Setting Excel 2013 default theme

I want to change the default theme for Excel, so that when I open a new blank document, the right fonts and colors are in place. I've come so far as to make a theme and set it as default, but for some ...

**2**

votes

**2**answers

77 views

### Excel 2013 VBA programming

I'll start off my saying I'm trying to save time for a family member who is doing this program manually.
Sheet 1
Column A is a start date
Column B is a projected start date
Column E is a Task Name.
...

**1**

vote

**1**answer

26 views

### Different colored columns in excel

I have data such as this:
1 | 2 | Y
2 | 4 | N
3 | 3 | N
4 | 2 | Y
...
I need a bar graph that will display column 1 as the x-axis labels with column 2 as the y values. The color of each bar will be ...

**-2**

votes

**0**answers

33 views

### How to write this Excel formula in MS Access 2013

In Access I have a table with 2 columns [Name] and [Rank]
Here is some sample data:
[Name] [Rank]
AMAVX 1
AMAVX 2
AMAVX 3
AMAVX 4
AMAVX 5
AMAVX 6
BTYMA 1
BTYMA 2
BTYMA 3
...

**0**

votes

**0**answers

4 views

### Pivot Table and hiding 0 values in columns

Have a pivot table that counts resources from different locations by month summary such as:
February March April May...
Toronto 10 10 11 11
Montreal 0 0 ...

**1**

vote

**1**answer

53 views

### Excel formula to show FORMULA

Ok, guys. I am 100% sure that a few days ago I saw and tested a real built-in Excel formula for showing a formula as text in any cell. Now, when I need it, I cannot find it!!! No VBA, no tricks. Just ...

**-1**

votes

**1**answer

13 views

### Conditional formatting (alternating between only two colours) of rows depending on cell values

How do i get conditional formatting done depending on values of cells.
I need to get the cells (and their rows) formatted in only two colours
Say,A1 has Colour1
if A2=A1, then A2 should get ...

**0**

votes

**1**answer

21 views

### How to get latest date (most recent date) in Excel?

I have two dates in one column.
I want get last date (large date or the most recent date)
so when I use =MAX(A1:A10) it returns a value (42343) like this or similar.
How to get the latest date by ...