The 2013 version of Microsoft's spreadsheet application.

learn more… | top users | synonyms (1)

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